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 |
|
crugerenator
Posting Yak Master
126 Posts |
 Posted - 2008-04-17 : 12:36:07
|
| As of right now I have two networked machines. I have a sql database on one that I have no problem connecting to, but I cannot connect to the database from the second machine. From the second machine, I've come up with this connection string after all my research..."server=[MACHINE_NAME]\SQLExpress;databse=[NAME];User ID = sa;Password=[PASS]"I keep getting a cannot connect to database error. Any ideas? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-17 : 12:43:24
|
| Whats the error you're getting? Have you enabled remote connections for your db in surface area condfiguration manager? |
 |
|
|
crugerenator
Posting Yak Master
126 Posts |
Posted - 2008-04-17 : 13:23:34
|
| I did change the surface area configuration. I set it to allow named and IP/TCP remote connections.The error message just says could not locate server. |
|
|
|
crugerenator
Posting Yak Master
126 Posts |
Posted - 2008-04-17 : 13:24:56
|
| Do I need to enable SQL Server Browser? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-17 : 13:31:11
|
| Check www.connectionstrings.comFrom SQL - you need to setup linked server |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-19 : 18:21:15
|
| Nothing to do with linked server here.>> Do I need to enable SQL Server Browser?Yes if sql is listening on dynamic port and you connect with tcp/ip protocol. Can you ping sql server from those machines? |
|
|
|
|
|
|
Connecting to SqlExpress