Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

SQL data source, missing server

I am trying to set up a data source on a client PC to a SQL 2005 server.
I have it set up on my PC and I can see the data.
If I log in to the other PC the server does not appear in the drop down list and I get 'Server does not exist or access denied' message.
Can anyone help?
0
HKFuey
Asked:
HKFuey
  • 6
  • 3
  • 2
1 Solution
 
RiteshShahCommented:
how do you trying to access server? are both computers in same network? can you ping your PC from other PC?
0
 
RiteshShahCommented:
One more thing, are you trying to access from windows authentication or from SQL authentication?
0
 
zadeveloperCommented:
try

SqlConnection cn = new SqlConnection("Data Source=SERVERIPADDRESS;Initial Catalog=DATABASENAME;UID=SQLUSERNAME;PWD=SQLPASSWORD")

Open in new window

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
HKFueyAuthor Commented:
Server is on same network and I can see it on both PC's
I have tried both Windows and SQL Authentication
0
 
RiteshShahCommented:
can you please run following command on DOS prompt in both the PCs?

sqlcmd -L

it will list you all instance of SQL Server in your network. moreover, you will get exact name of your instance so that you can use it properly.
0
 
zadeveloperCommented:
Can you connect using management studio ?
0
 
RiteshShahCommented:
apart from my previous answer, you could do one more thing, enable remote connection if it is not so far because it might denied for access.

following links may be useful for that.

http://geekswithblogs.net/jaykinker/archive/2006/10/06/93334.aspx

http://www.linglom.com/2007/08/31/enable-remote-connection-to-sql-server-2005-express/


0
 
HKFueyAuthor Commented:
SQL server browser service was disabled!!!!
 
it is now working. Thanks for the help.
0
 
RiteshShahCommented:
also enable your SQL Browser service if it is disable, you can find it in control panel->administrative tools->services
0
 
RiteshShahCommented:
>>
SQL server browser service was disabled!!!!
 
it is now working. Thanks for the help.<<

great, that was written in first link in post # 26281859 above, along with few other reasons.

0
 
HKFueyAuthor Commented:
Found answer by checking services
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 6
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now