ConnectionOpen(Connect()) in SQL server 2000

hi,
i am new to SQL Server 2000 n trying to set up a Server in Windows 200
pro,
but whenever i try to Register the server it fails n gives the below
error,
ConnectionOpen(Connect()) faIled.
plz if some one can rectify this issue,
thanks in advance,
mandeepFirstly check if your SQL Server services are running; If yes then
proceed
Start-->programs --> Microsoft SQL Server --> Client Network Utility
Check to see if TCP/IP and NamedPipes are enabled only check if Shared
Memory is checked, if its not checked, check it

Connection String to SQL Express on another computer

I have an XP Pro machine running a classic ASP site in IIS - the version that comes on the XP Pro CD. The site makes a connection to an MSDE database on the same machine named InControl. I have moved that database to SQL Express 2005 and want to test it with the ASP site. SQL Express 2005 is running on a separate Vista machine. I am currently using this connection string:

objConn.ConnectionString = "Provider=SQLOLEDB;Data Source=400SC;Initial Catalog=InControl;User ID=" & uid & ";Password=" & upass & ""

Where 400SC is the name of the XP Pro machine and InControl is the database. The variables uid and upass are pulled from Session when the connection string is created.

I have tried different Provider names and various combinations of server name and ip address with and without port numbers for the Data Source. All of them yield some variation of this error:

Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

What should the connection string look like?

Thanks for the help.

PS - If the solution involves a port, do I need to make that port an exception in the Vista Firewall?

The sqlexpress server may have an instance name. Try changing it to "Data Source=400SC\SQLEXPRESS"

|||

This is the string I initially tried to access SQL Express on the other computer - CSC_DELL. I recieved the error message in the original post. Hard coding the User ID and Password also yeilds the same error. The User is set-up in SQL and the database.

objConn.ConnectionString = "Provider=SQLOLEDB;Data Source=CSC_DELL\SQLEXPRESS;Initial Catalog=InControl;User ID=" & uid & ";Password=" & upass & ""

|||

Create a new file on your desktop. Rename the file to "test.udl" Double-click the file, and create a connection to your database. Once the "Test Connection" succeeds, then close the dialog box and view the contents of your .udl file in notepad. This will give you a connection string to compare against.

|||

Created a .udl file, but the SQL Express server on the Vista machine was not listed in the Server drop down list. I used the SQL Configuration tool and enabled listening with TCP/IP and Named Pipes - both were disabled. Also made a 1433 port exception in the Vista firewall. Tried udl, again, and the server still did not show. Both computers are in the same workgroup on my home network. I tried typing the name of the SQL Express server in the drop down list - didn't work. Everything I try yields the "SQL Server does not exist or access denied." Still stuck.

Connection String

I have SQL Server 2000 installed on my XP Pro PC and the Client Tools (SQL
Query Analyzer) installed on my 98SE PC. On the 98SE PC, when I start SQL
Query Analyzer, I get a window titled "Connect to SQL Server" but the SQL
Server line is blank and the drop-down arrow is also blank. How do I get the
SQL Server 2000 to show up here? Thanks in advance for any help on this. I
built the 98SE machine especially to access the database files that are on
the SQL Server 2000 but, so far, I have been unable to connect to the
server. Jim.The drop down shows what servers you have connected to not
necessarily what servers are available. Type the server name
in and try connecting.
-Sue
On Sun, 12 Jun 2005 14:15:42 GMT, "Jim Richards"
<JWRichards@.satx.rr.com> wrote:

>I have SQL Server 2000 installed on my XP Pro PC and the Client Tools (SQL
>Query Analyzer) installed on my 98SE PC. On the 98SE PC, when I start SQL
>Query Analyzer, I get a window titled "Connect to SQL Server" but the SQL
>Server line is blank and the drop-down arrow is also blank. How do I get th
e
>SQL Server 2000 to show up here? Thanks in advance for any help on this. I
>built the 98SE machine especially to access the database files that are on
>the SQL Server 2000 but, so far, I have been unable to connect to the
>server. Jim.
>|||Thank you Sue. You said: "Type the server name in and try connecting." The
name of the computer on which the Server resides is "JIMRIC" and is accessed
over a LAN. The name of the Server is "local". Do I type in:
\\JIMRIC\(local) , if not, what do I type in Please.
BTW, I also have the SQL Query Analyzer on the XP Pro PC and I have no
trouble connecting to the server there. The server is entered here as
(local). Jim.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:8msqa1loi5kortnt885spitum19pof9rdj@.
4ax.com...
> The drop down shows what servers you have connected to not
> necessarily what servers are available. Type the server name
> in and try connecting.
> -Sue
> On Sun, 12 Jun 2005 14:15:42 GMT, "Jim Richards"
> <JWRichards@.satx.rr.com> wrote:
>
>|||When it's on the box where you are running the tools, you
can use (local) for the default instance. From other
computers, you need to specify the server name and from the
local server you can specify the server name.
ServerName\OtherName is used for connecting to named
instances.
If you are using (local) from another PC, it's not
connecting to another server in the network. It's connecting
to a SQL Server (or MSDE) instance on that PC.
-Sue
On Mon, 13 Jun 2005 15:26:58 GMT, "Jim Richards"
<JWRichards@.satx.rr.com> wrote:

>Thank you Sue. You said: "Type the server name in and try connecting." The
>name of the computer on which the Server resides is "JIMRIC" and is accesse
d
>over a LAN. The name of the Server is "local". Do I type in:
>\\JIMRIC\(local) , if not, what do I type in Please.
>BTW, I also have the SQL Query Analyzer on the XP Pro PC and I have no
>trouble connecting to the server there. The server is entered here as
>(local). Jim.
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:8msqa1loi5kortnt885spitum19pof9rdj@.
4ax.com...
>|||Thank you Sue and I will show my ignorance and ask then how do I know what
name to type in? TIA, Jim.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1fgsa1db7tqfqdddqfs1d01510ggrn9m9i@.
4ax.com...
> When it's on the box where you are running the tools, you
> can use (local) for the default instance. From other
> computers, you need to specify the server name and from the
> local server you can specify the server name.
> ServerName\OtherName is used for connecting to named
> instances.
> If you are using (local) from another PC, it's not
> connecting to another server in the network. It's connecting
> to a SQL Server (or MSDE) instance on that PC.
> -Sue
> On Mon, 13 Jun 2005 15:26:58 GMT, "Jim Richards"
> <JWRichards@.satx.rr.com> wrote:
>
>

Connection String

I have SQL Server 2000 installed on my XP Pro PC and the Client Tools (SQL
Query Analyzer) installed on my 98SE PC. On the 98SE PC, when I start SQL
Query Analyzer, I get a window titled "Connect to SQL Server" but the SQL
Server line is blank and the drop-down arrow is also blank. How do I get the
SQL Server 2000 to show up here? Thanks in advance for any help on this. I
built the 98SE machine especially to access the database files that are on
the SQL Server 2000 but, so far, I have been unable to connect to the
server. Jim.
The drop down shows what servers you have connected to not
necessarily what servers are available. Type the server name
in and try connecting.
-Sue
On Sun, 12 Jun 2005 14:15:42 GMT, "Jim Richards"
<JWRichards@.satx.rr.com> wrote:

>I have SQL Server 2000 installed on my XP Pro PC and the Client Tools (SQL
>Query Analyzer) installed on my 98SE PC. On the 98SE PC, when I start SQL
>Query Analyzer, I get a window titled "Connect to SQL Server" but the SQL
>Server line is blank and the drop-down arrow is also blank. How do I get the
>SQL Server 2000 to show up here? Thanks in advance for any help on this. I
>built the 98SE machine especially to access the database files that are on
>the SQL Server 2000 but, so far, I have been unable to connect to the
>server. Jim.
>
|||Thank you Sue. You said: "Type the server name in and try connecting." The
name of the computer on which the Server resides is "JIMRIC" and is accessed
over a LAN. The name of the Server is "local". Do I type in:
\\JIMRIC\(local) , if not, what do I type in Please.
BTW, I also have the SQL Query Analyzer on the XP Pro PC and I have no
trouble connecting to the server there. The server is entered here as
(local). Jim.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:8msqa1loi5kortnt885spitum19pof9rdj@.4ax.com...
> The drop down shows what servers you have connected to not
> necessarily what servers are available. Type the server name
> in and try connecting.
> -Sue
> On Sun, 12 Jun 2005 14:15:42 GMT, "Jim Richards"
> <JWRichards@.satx.rr.com> wrote:
>
|||When it's on the box where you are running the tools, you
can use (local) for the default instance. From other
computers, you need to specify the server name and from the
local server you can specify the server name.
ServerName\OtherName is used for connecting to named
instances.
If you are using (local) from another PC, it's not
connecting to another server in the network. It's connecting
to a SQL Server (or MSDE) instance on that PC.
-Sue
On Mon, 13 Jun 2005 15:26:58 GMT, "Jim Richards"
<JWRichards@.satx.rr.com> wrote:

>Thank you Sue. You said: "Type the server name in and try connecting." The
>name of the computer on which the Server resides is "JIMRIC" and is accessed
>over a LAN. The name of the Server is "local". Do I type in:
>\\JIMRIC\(local) , if not, what do I type in Please.
>BTW, I also have the SQL Query Analyzer on the XP Pro PC and I have no
>trouble connecting to the server there. The server is entered here as
>(local). Jim.
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:8msqa1loi5kortnt885spitum19pof9rdj@.4ax.com.. .
>
|||Thank you Sue and I will show my ignorance and ask then how do I know what
name to type in? TIA, Jim.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1fgsa1db7tqfqdddqfs1d01510ggrn9m9i@.4ax.com...
> When it's on the box where you are running the tools, you
> can use (local) for the default instance. From other
> computers, you need to specify the server name and from the
> local server you can specify the server name.
> ServerName\OtherName is used for connecting to named
> instances.
> If you are using (local) from another PC, it's not
> connecting to another server in the network. It's connecting
> to a SQL Server (or MSDE) instance on that PC.
> -Sue
> On Mon, 13 Jun 2005 15:26:58 GMT, "Jim Richards"
> <JWRichards@.satx.rr.com> wrote:
>