When I try to connect to my SQL server 2000 which is
installed on WIN 2000 server. The folloeing message box
appears:
"This service doesn't exist as an installed service", also
in some ocasions it will give me error 1060.
This SQL server instance was working ok, till I removed an
application which removed MSDE too.(I have other instances
which work ok)
Did I lose all my other databases in this instance? Is
there anyway that I can recover this instance?
Thanks for help in Advance.
MarkI don't know i should see
but it seems your are trying to login using an SQL account
and not using the integrated windows security.
"Mark" <mpaydar@.yahoo.com> wrote in message
news:1869d01c42055$2fa0c1b0$a601280a@.phx
.gbl...
> When I try to connect to my SQL server 2000 which is
> installed on WIN 2000 server. The folloeing message box
> appears:
> "This service doesn't exist as an installed service", also
> in some ocasions it will give me error 1060.
> This SQL server instance was working ok, till I removed an
> application which removed MSDE too.(I have other instances
> which work ok)
> Did I lose all my other databases in this instance? Is
> there anyway that I can recover this instance?
> Thanks for help in Advance.
> Mark|||-Try connecting to the SQL instance using OSQL or SQL Client tools.
-Look at Control Panel | Services and check if you see the MSSQLSERVER or
MSSQL$<Instance Name> service.
-Search for *.mdf to see if any database files till exist.
Thanks
Deepali
This posting is provided "AS IS" with no warranties, and confers no rightssql
Showing posts with label exist. Show all posts
Showing posts with label exist. Show all posts
Friday, March 30, 2012
I get this error on my SQL server 2000
When I try to connect to my SQL server 2000 which is
installed on WIN 2000 server. The folloeing message box
appears:
"This service doesn't exist as an installed service", also
in some ocasions it will give me error 1060.
This SQL server instance was working ok, till I removed an
application which removed MSDE too.(I have other instances
which work ok)
Did I lose all my other databases in this instance? Is
there anyway that I can recover this instance?
Thanks for help in Advance.
Mark
I don't know i should see
but it seems your are trying to login using an SQL account
and not using the integrated windows security.
"Mark" <mpaydar@.yahoo.com> wrote in message
news:1869d01c42055$2fa0c1b0$a601280a@.phx.gbl...
> When I try to connect to my SQL server 2000 which is
> installed on WIN 2000 server. The folloeing message box
> appears:
> "This service doesn't exist as an installed service", also
> in some ocasions it will give me error 1060.
> This SQL server instance was working ok, till I removed an
> application which removed MSDE too.(I have other instances
> which work ok)
> Did I lose all my other databases in this instance? Is
> there anyway that I can recover this instance?
> Thanks for help in Advance.
> Mark
|||-Try connecting to the SQL instance using OSQL or SQL Client tools.
-Look at Control Panel | Services and check if you see the MSSQLSERVER or
MSSQL$<Instance Name> service.
-Search for *.mdf to see if any database files till exist.
Thanks
Deepali
This posting is provided "AS IS" with no warranties, and confers no rights
installed on WIN 2000 server. The folloeing message box
appears:
"This service doesn't exist as an installed service", also
in some ocasions it will give me error 1060.
This SQL server instance was working ok, till I removed an
application which removed MSDE too.(I have other instances
which work ok)
Did I lose all my other databases in this instance? Is
there anyway that I can recover this instance?
Thanks for help in Advance.
Mark
I don't know i should see
but it seems your are trying to login using an SQL account
and not using the integrated windows security.
"Mark" <mpaydar@.yahoo.com> wrote in message
news:1869d01c42055$2fa0c1b0$a601280a@.phx.gbl...
> When I try to connect to my SQL server 2000 which is
> installed on WIN 2000 server. The folloeing message box
> appears:
> "This service doesn't exist as an installed service", also
> in some ocasions it will give me error 1060.
> This SQL server instance was working ok, till I removed an
> application which removed MSDE too.(I have other instances
> which work ok)
> Did I lose all my other databases in this instance? Is
> there anyway that I can recover this instance?
> Thanks for help in Advance.
> Mark
|||-Try connecting to the SQL instance using OSQL or SQL Client tools.
-Look at Control Panel | Services and check if you see the MSSQLSERVER or
MSSQL$<Instance Name> service.
-Search for *.mdf to see if any database files till exist.
Thanks
Deepali
This posting is provided "AS IS" with no warranties, and confers no rights
Friday, March 23, 2012
I cant make new SQL Server Registration
When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?Hi, Check the User name and the password.
one more thing ..check whether the sql server is accessible from ur machine or not. use the ping command to check it.
cheers
gola munjal
Originally posted by yajai
When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?|||Make sure to have similar netlibs as default on server and client.
Try connecting with TCP/IP.|||when i ping host, result is
Pinging 216.58.174.179 with 32 bytes of data:
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Ping statistics for 216.58.174.179:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)
what does it mean?|||How I connect TCP/IP?|||If the PING is not successful then how can you connect?
Take a help of NETWORK Admin to resolve the connectivity first.
Refer to this KBA (http://support.microsoft.com/default.aspx?scid=/support/sql/content/connect/ClientIP.asp) for more information.
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?Hi, Check the User name and the password.
one more thing ..check whether the sql server is accessible from ur machine or not. use the ping command to check it.
cheers
gola munjal
Originally posted by yajai
When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?|||Make sure to have similar netlibs as default on server and client.
Try connecting with TCP/IP.|||when i ping host, result is
Pinging 216.58.174.179 with 32 bytes of data:
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Ping statistics for 216.58.174.179:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)
what does it mean?|||How I connect TCP/IP?|||If the PING is not successful then how can you connect?
Take a help of NETWORK Admin to resolve the connectivity first.
Refer to this KBA (http://support.microsoft.com/default.aspx?scid=/support/sql/content/connect/ClientIP.asp) for more information.
Subscribe to:
Posts (Atom)