i couldn't see Databases in SQL server
-
I am working on Windows 2000 professional. I have installed MSDE 2000 and also SQL server 2000 (Client components only). But when i go through the Enterprise Manager of SQL Server, it is not identifying any server. It is displaying something like: Server is not found or Access denied. Connection Open when i tried to run in command prompt also (C:/>osql ....) it is saying connection open error. can anyone please help? thank you
-
I am working on Windows 2000 professional. I have installed MSDE 2000 and also SQL server 2000 (Client components only). But when i go through the Enterprise Manager of SQL Server, it is not identifying any server. It is displaying something like: Server is not found or Access denied. Connection Open when i tried to run in command prompt also (C:/>osql ....) it is saying connection open error. can anyone please help? thank you
BSRK wrote: Server is not found or Access denied A couple of things to check: Is the SQL Server service running? Are you connecting with the correct user namd and password?
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
Upcoming talk: SELECT UserName, Password FROM Users -- Getting unauthorised access to a SQL Server, and how to prevent it.
-
BSRK wrote: Server is not found or Access denied A couple of things to check: Is the SQL Server service running? Are you connecting with the correct user namd and password?
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
Upcoming talk: SELECT UserName, Password FROM Users -- Getting unauthorised access to a SQL Server, and how to prevent it.
-
I have checked from Administrative Tools -> Services, that sQL server service is running. still i have this problem. Can you tell me whether i need to install service pack SP3a in addition with MSDE 2000?
BSRK wrote: Can you tell me whether i need to install service pack SP3a in addition with MSDE 2000? Installing Service Pack 3a is generally a good idea anyway because, IIRC, it contains the security fix for the Slammer worm. BSRK wrote: I have checked from Administrative Tools -> Services, that sQL server service is running. So, are you attempting to log in using the correct credentials? Have you typed the user name and password correctly? Did you set it to use Windows Authentication? and if yes, are you trying to connect using the same account that it was installed with (or with an account that has been granted access)?
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
Upcoming talk: SELECT UserName, Password FROM Users -- Getting unauthorised access to a SQL Server, and how to prevent it.
-
BSRK wrote: Can you tell me whether i need to install service pack SP3a in addition with MSDE 2000? Installing Service Pack 3a is generally a good idea anyway because, IIRC, it contains the security fix for the Slammer worm. BSRK wrote: I have checked from Administrative Tools -> Services, that sQL server service is running. So, are you attempting to log in using the correct credentials? Have you typed the user name and password correctly? Did you set it to use Windows Authentication? and if yes, are you trying to connect using the same account that it was installed with (or with an account that has been granted access)?
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
Upcoming talk: SELECT UserName, Password FROM Users -- Getting unauthorised access to a SQL Server, and how to prevent it.
I think we cannot use MSDE & Enterprise Manager in conjunction. i got similar info from the below link. http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?&query=FAQ&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.msde&p=1&tid=2b4fe8b6-3d8d-4353-8f91-31c0f60bba14[^]
-
I think we cannot use MSDE & Enterprise Manager in conjunction. i got similar info from the below link. http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?&query=FAQ&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.msde&p=1&tid=2b4fe8b6-3d8d-4353-8f91-31c0f60bba14[^]
BSRK wrote: I think we cannot use MSDE & Enterprise Manager in conjunction Curious - I've never had a problem combining using Enterprise Manager with an MSDE database.
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
Upcoming talk: SELECT UserName, Password FROM Users -- Getting unauthorised access to a SQL Server, and how to prevent it.
-
I think we cannot use MSDE & Enterprise Manager in conjunction. i got similar info from the below link. http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?&query=FAQ&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.msde&p=1&tid=2b4fe8b6-3d8d-4353-8f91-31c0f60bba14[^]
MSDE and Enterprise manager work fine together. There is a grey area when it comes to the licencing of the software. But there is no technical reason why Enterprise Manager can't see your MSDE database. Michael CP Blog [^] Development Blog [^]
-
I am working on Windows 2000 professional. I have installed MSDE 2000 and also SQL server 2000 (Client components only). But when i go through the Enterprise Manager of SQL Server, it is not identifying any server. It is displaying something like: Server is not found or Access denied. Connection Open when i tried to run in command prompt also (C:/>osql ....) it is saying connection open error. can anyone please help? thank you
A new installation of MSDE is configured in Windows Authentication mode. You must use a trusted connection (e.g. osql -E) to connect to it. If you want to be able to supply a username and password you will need to reconfigure for mixed mode. If you downloaded MSDE recently, you will have MSDE Release A. If you accept the default install parameters, this version of MSDE disables all networking protocols. You can only access it from the machine it's installed on, using the Shared Memory protocol. Follow the instructions in KB 814130[^] to re-enable network access. Stability. What an interesting concept. -- Chris Maunder