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 |
|
tomkemp
Starting Member
2 Posts |
 Posted - 2006-02-03 : 05:11:44
|
| I've installed MSDE 2000 on a server with an instance name and attached a database to it. On the server I can use osql to look at the database, add new users etc. So the database is working fine.On the client I have installed an adp with a .ini file which it reads to find the name of the server (servercomputername\instancename) and the name of the database to create a connection string.It thinks for a while and then comes up with an error of Access Denied or SQL Server does not exist.The logged in user is an authorised user of the database (using sp_grantlogin and sp_grantdbaccess)Thinking I was doing something wrong in the connection string, I tried to create an ODBC connection (ie independently of the adp file) to the server. The server computer name came up on the list of servers so it recognised that there is a SQL Server instance running but if I entered servercomputername\instancename in the dialog and continued, I got the same error message.Using svrnetcn.exe I checked that the MSDE instance has TCP/IP and Named Pipes enabled. I set the default port to 1433 but this made no difference.You realise by now I know very little about servers and networks! What else should I check or set? |
|
|
tomkemp
Starting Member
2 Posts |
Posted - 2006-02-06 : 14:00:51
|
| Found the answer today so thought I'd share it. I upgraded MSDE to service pack 4 and everything went fine. Clients can now see the database.Tom |
 |
|
|
JonnyG
Starting Member
26 Posts |
Posted - 2006-03-22 : 16:23:41
|
| I have found that when I experience this problem it is because the client pc does not have the latest version of MDAC. Installing MDAC v2.8 on the client fixes the problem. |
|
|
|
|
|
|
client can't see MSDE