New to SQL

Hi
I am setting for the first time SQL to access a database. I can get the
Enterprise Manager and the Network Utility to see the databases (on 2
computers) but when I go to the program to access the databases, I get a
Connection error.
Strangely, I set up the exact replica on the server and it can only see
itself and not the other computer.
I have scanned newsgroups etc but cannot locate the problem.
Thanks
cds
Could you please post the exact error message? There are various types of
connectivity issues, and we need to see the error message, to be able to
understand what's happening.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"cds" <cdsaus2001@.yahoo.com.au> wrote in message
news:4140ccde$0$3711$afc38c87@.news.optusnet.com.au ...
> Hi
> I am setting for the first time SQL to access a database. I can get the
> Enterprise Manager and the Network Utility to see the databases (on 2
> computers) but when I go to the program to access the databases, I get a
> Connection error.
> Strangely, I set up the exact replica on the server and it can only see
> itself and not the other computer.
> I have scanned newsgroups etc but cannot locate the problem.
> Thanks
> cds
>
sql

New IBM Laptop running SQL server cannot connect to another sql server on network

I am trying to connect a new LBM Laptop to an SQL server on the
network
and I get "test connection failed because of an error in initializing
provider, [dbnetlib][connectionopren(connect()),] SQL server does not
exist or access denied. The laptom has sql server running on it
locally and I am trying to connect to an SQL server on the network.
Thanks
TomHi

You should make sure that SQL Server is at Service Pack 3a on both machines
and check the MDAC installation on the laptop with the MDAC component
checker (see microsoft download centre)?

If you can connect to the network SQL Server from other machines, then check
the network settings on the laptop.

John

"TomCullen" <cullentw2000@.yahoo.com> wrote in message
news:6ba80eaf.0410220926.6c2f4355@.posting.google.c om...
> I am trying to connect a new LBM Laptop to an SQL server on the
> network
> and I get "test connection failed because of an error in initializing
> provider, [dbnetlib][connectionopren(connect()),] SQL server does not
> exist or access denied. The laptom has sql server running on it
> locally and I am trying to connect to an SQL server on the network.
> Thanks
> Tom

New file notification

Hi All,

I am vey new to NS and here is what I am trying to achive:

User creates/copies over a file on the network. When this happens, I want to start an existing Job (SQL stored procedure) in SQL Server Agent.

Any lead (existing sample applications etc.) for me to start is apprecitated.

Thank you.

You can make use of the inbuilt "Event Provider" that monitors a specific folder. For more information, read about "Event Providers"|||Is this for some kind of ETL process? I'm not sure that SSNS is the best tool available for you here.

If you believe that it is the best tools, consider these options:

SSNS does come with a FileSystemWatcher event provider, but it looks for a valid XML document in the watched folder. If you're files are something besides a valid XML document, you can create a custom event provider using any .NET Framework language.

SSNS is designed to deliver notifications rather than start processes. So, you would need to create a custom delivery channel to start your SQL Server Agent process.

HTH...

Joe|||

Thank you Ragas. I looked at some online examples and worked it out. This article was quite helpfull:

http://www.devx.com/dbzone/Article/28522

|||

Thank you Joe. Yes, it is an ETL process and SSNS works pretty well. I downloaded this example and figured it out eventually: http://www.devx.com/dbzone/Article/28522

I added a trigger to start my SQL Agent job on one of the Notification Application tables when a new notification record is created.

AE

|||That's great, AE.

Is there anything that you could share with the group?

Thanks!

Joe|||

No Joe, just the link I provided for a good sample application in my previous message.

Ahmet

New file notification

Hi All,

I am vey new to NS and here is what I am trying to achive:

User creates/copies over a file on the network. When this happens, I want to start an existing Job (SQL stored procedure) in SQL Server Agent.

Any lead (existing sample applications etc.) for me to start is apprecitated.

Thank you.

You can make use of the inbuilt "Event Provider" that monitors a specific folder. For more information, read about "Event Providers"|||Is this for some kind of ETL process? I'm not sure that SSNS is the best tool available for you here.

If you believe that it is the best tools, consider these options:

SSNS does come with a FileSystemWatcher event provider, but it looks for a valid XML document in the watched folder. If you're files are something besides a valid XML document, you can create a custom event provider using any .NET Framework language.

SSNS is designed to deliver notifications rather than start processes. So, you would need to create a custom delivery channel to start your SQL Server Agent process.

HTH...

Joe|||

Thank you Ragas. I looked at some online examples and worked it out. This article was quite helpfull:

http://www.devx.com/dbzone/Article/28522

|||

Thank you Joe. Yes, it is an ETL process and SSNS works pretty well. I downloaded this example and figured it out eventually: http://www.devx.com/dbzone/Article/28522

I added a trigger to start my SQL Agent job on one of the Notification Application tables when a new notification record is created.

AE

|||That's great, AE.

Is there anything that you could share with the group?

Thanks!

Joe|||

No Joe, just the link I provided for a good sample application in my previous message.

Ahmet

New database on other local network drive

Hello,

I need help with the setup of my sql server express 2005 and more specifically, with the location of the database files. Normally, database files are located on the c: drive. In my situation, being in a high school environnement, I need to have the database files on the network drive ... lets call it g:\drive. The reason why it cannot be on c:\drive is because this drive is protected using DeepFreeze. Now, I was able to change the location of the new drive as I went into the properties window of the sql server instance but when I try to create this new database, sql gives me grief ;-|

I am from the group of people that thinks that to anything, there is a solution and am hoping that to this problem, there is hope of a solution.

Can anyone help?

Thank you

Yep there is Trace flag 1807 when you add that to your CREATE DATABASE statement it will be accepted, I found Microsoft documentation of the requirement and a link showing how easy it is to run DBCC TRACEON before executing your CREATE DATABASE statement. Hope this helps.

http://support.microsoft.com/default.aspx?scid=304261

http://www.yafla.com/dennisforbes/SAN-NAS-and-iSCSI-SQL-Server-/SAN-NAS-and-iSCSI-SQL-Server-.html