Re: MSDE Database move to a new Server - any SQL guru's out there?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Glad I was able to point you in the right direction. Sorry I didn't see your reply earlier or I could have given more direct instructions. Thanks for posting back with your final solution though! Good luck!

-Cliff


"Lesa H." <itsplesa@xxxxxxxxxxxxxx> wrote in message news:e4DWYL5YKHA.1336@xxxxxxxxxxxxxxxxxxxxxxx
Thanks so much Cliff!! You were able to lead me to the right place to get it fixed. I did the following (for anyone else who might have this problem):

a.. Click Start, Run
a.. Enter svrnetcn.exe to run the "SQL Server Network Utility"
a.. Select "TCP/IP" from the Disabled protocols and click "Enable >>
a.. I enabled Named Pipes just for good measure.

Thanks again,

Lesa

"Lesa H." <itsplesa@xxxxxxxxxxxxxx> wrote in message news:uVN2X14YKHA.4148@xxxxxxxxxxxxxxxxxxxxxxx
It's MSDE (SQL 2000 SP4). I've got the SQL Studio Management Express installed, so I can look at the properties with that if needed. I just couldn't find where to make it accept remote connections.

"Cliff Galiher" <cgaliher@xxxxxxxxx> wrote in message news:%2335mWb2YKHA.3712@xxxxxxxxxxxxxxxxxxxxxxx
SQL Server does not allow remote connections by default. This needs to be enabled. Which version of SQL server did you migrate the instance to?

-Cliff


"Lesa H." <itsplesa@xxxxxxxxxxxxxx> wrote in message news:e8vTuG0YKHA.5852@xxxxxxxxxxxxxxxxxxxxxxx
I'm sorry for the cross post, but I have a new customer that I need to get up and running on this new server. Here's the situation:

First let me say that I don't have much experience with SQL so bear with me here. I have a client that has a MSDE 2000 database on their old server and want to move it to the new server. I created a database instance on the new server with the same database instance name as the old server. The new server has a different name, but the database instance on both is the same.

The database service for the new instance is shown in the services and it is running. I detached the database files on the old server and then copied them from the folder on the old server to the new server. I used the SQL Express Management utility to connect to the instance and then attached the database files on the new server. I setup security to match the old server with SQL and Windows Authentication. I can connect to the database and create a DSN if I'm logged directly into the new server on that server, but if I try to create a DSN from one of the other computers in the network, I get an error message that the server doesn't exist or is not running even if I'm logged into the workstation as an administrator. The error is as follows:

Connection failed:
SQLState:'01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

I'm sure I'm missing something simple, but I can't figure out what it is. Can anyone help me??

TIA

Lesa







.

Relevant Pages