Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ExCelciuS
Starting Member
3 Posts |
 Posted - 2010-07-30 : 03:14:01
|
Hi,I have a client program which I want to connect to SQL Server 2005 Express through TCP/IP.I have set "allow remote connection" on SQL Server 2005 Express through SQL Server Surface Area Configuration tool , and I've used this connection string (this is just for example, in real I have set this with the right values) :Server=190.190.200.100,1433;Network Library=DBMSSOCN;Database=myDataBase;User ID=myUsername;Password=myPassword; But I got this error message: Do you know how to resolve this problem?Thanks,Kev. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-30 : 03:22:25
|
Don't miss the server name syntax Servername\SQLEXPRESS where you substitute Servername with the name of the computer where the SQL Server 2005 Express installation resides.http://www.connectionstrings.com/sql-server-2005
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
ExCelciuS
Starting Member
3 Posts |
Posted - 2010-07-30 : 04:07:47
|
quote:
Originally posted by webfred
Don't miss the server name syntax Servername\SQLEXPRESS where you substitute Servername with the name of the computer where the SQL Server 2005 Express installation resides.http://www.connectionstrings.com/sql-server-2005
No, you're never too old to Yak'n'Roll if you're too young to die.
Hello webfred, what do you mean by Servername? I'm using TCP/IP connection here (via IP Address), so is it 190.190.200.100\SQLEXPRESS? Is the connection string become like this:Data Source=190.190.200.100,1433\SQLEXPRESS;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; Is that correct? Or could you show me the correct connection string example based on your previous answer? |
|
|
|
|
|
|
Can't Connect to Server using TCP/IP