| Author |
Access 2000 Upsizing Wizard with SQL Server 2000 Developer
|
|
|
| I am getting the following message and I am not sure why.
Connection failed:
SQL State: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Con
nection Open (Connect()).
Connection failed:
SQL State: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or
access denied.
I used the default settings to name the Server [local] and I double checked
through Enterprise Manager that I could see the server and the databases.
Any ideas on what is wrong? I am new to SQL Server.
CLM
| |
| Brendan Reynolds 2005-04-06, 8:05 pm |
| In the newsgroup post, you have typed square brackets instead of parentheses
around the word 'local'. Is it possible that you may have made the same
error in the connection string? That would produce exactly the error message
you describe.
--
Brendan Reynolds (MVP)
"CLM" <CLM@discussions.microsoft.com> wrote in message
news:6849CDDE-73B4-4802-B5F5- C20D01D7A137@microso
ft.com...
>I am getting the following message and I am not sure why.
>
> Connection failed:
> SQL State: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Con
nection Open (Connect()).
> Connection failed:
> SQL State: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or
> access denied.
>
> I used the default settings to name the Server [local] and I double
> checked
> through Enterprise Manager that I could see the server and the databases.
> Any ideas on what is wrong? I am new to SQL Server.
>
> CLM
| |
|
| Actually, it was the wrong name for the server to use. When I look at
Enterprise Manager it lists (local) under the SQL Server Group which is what
I thought the server name is, but when I just double checked using the
Service Manager it called it "LAPTOP". Apparently I had the wrong name.
Thanks for the help though.
CLM
"CLM" wrote:
> I am getting the following message and I am not sure why.
>
> Connection failed:
> SQL State: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Con
nection Open (Connect()).
> Connection failed:
> SQL State: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or
> access denied.
>
> I used the default settings to name the Server [local] and I double checked
> through Enterprise Manager that I could see the server and the databases.
> Any ideas on what is wrong? I am new to SQL Server.
>
> CLM
|
|
|
|