|
| | | Forum Newbie
Group: Forum Members
Last Login: 3/3/2005 10:53:00 AM
Posts: 1, Visits: 1 |
| I have been having trouble trying to make a System DSN work with WUPro 2005 remotely. Whenever I try to set it up, it cannot connect to the database. I would like to be able to write Crystal Reports and do some .NET programming with it. I usually would just create a System DSN and the go from there, but I cannot get past that part. I tried creating a new user besides sa that has all sorts of permissions, but it still gives and error when I try to connect. Here is what I do: I go to ODBC then click the System DSN tab. I click Add and Select SQL Server. For name I put in WhatsUp and Server I put in SERVERNAME/WHATSUP then hit next. Windows NT authentication does not seem to work so I use SQL Server Authentication and I put the loginID either as sa or with the new user I created and neither works. I get this: Connection failed: SQLState: '01000' SQL Server Error: 3 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()). Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. I get a similar error if I try to use the Enterprise Manager on a remote machine to connect to the SQL Server. If I am doing something wrong or forgetting something, please advise. I emailed technical support and they pointed me over here to get an answer. Thanks |
| |
| | | 
Time Traveler
Group: WhatsUp Gold Expert
Last Login: Today @ 1:49:13 PM
Posts: 1,513, Visits: 5,018 |
| By default MSDE does not accept network connections. You have to go in an admin program from ms (can't remember exactly but must be something like srvnetcn.exe or whatever).
From there you can open MSDE to accept network connections.
I think that the Ipswitch support team is having *some* problems because it turns out that many, many, many questions asked about WUP are in fact questions about MSDE. And Ipswitch is not really supposed to support MSDE, they just use it as the underlying DB. My guess is that, although they certainly did a good move when deciding to go for a database structure, they did not imagine that people would start asking questions about MSDE / SQL Server...
HTH
Reading, writing and arithmetic - If you need to choose, please take option 1. |
| |
| | | Supreme Being
Group: Forum Members
Last Login: 9/28/2005 11:33:00 AM
Posts: 128, Visits: 1 |
| | If you are running the MSDE install, you need to enable remote connections to the server. In the C:\Program Files\Microsoft SQL Server\80\Tools\Binn directory, there is a file called SVRNETCN.exe. This utility will let you configure connectivity to the server using any available protocols. Select TCP/IP then restart the instance of the server and you should be ready to rock. |
| |
|
|