That's OK Cliff. It only took me a couple of minutes once I read your post.
As usual, this group ROCKS!
Lesa
"Cliff Galiher" <> wrote in message
news:...
> 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." <> wrote in message
> news:...
>> 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." <> wrote in message
>> news:...
>>> 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" <> wrote in message
>>> news:%...
>>>> 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." <> wrote in message
>>>> news:...
>>>>> 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
>>>>>
>>>>>
>>>>>
>>>
>>>
>>
>>
|
Similar Threads
Linear Mode
