SQL Server - my sql server 2005 dont allow me to connect

Asked By elodie lodios
02-Nov-11 02:57 AM

hi, this is the message the show when i want to connect:

TITLE: Connect to
Server

------------------------------

 

Cannot connect to
FERNAND-PC\SQLEXPRESS.

 

------------------------------

ADDITIONAL
INFORMATION:

 

This version of
Microsoft SQL Server Management Studio can only be used to connect to SQL
Server 2000 and SQL Server 2005 servers. (ConnectionDlg)

 

------------------------------

BUTTONS:

 

OK

------------------------------

  dipa ahuja replied to elodie lodios
02-Nov-11 02:58 AM

You can't use SQL 2005 management studio to connect SQL 2008. In simple you can use SQL client tools to connect lower version of SQL and not higher higher version. You need to download SSMSE for SQL 2008, check out the link below

http://msdn.microsoft.com/en-us/library/ms365247.aspx

  James H replied to elodie lodios
02-Nov-11 03:00 AM
Hi This Message Showing that

This version of
Microsoft SQL Server Management Studio can only be used to connect to SQL
Server 2000 and SQL Server 2005 servers. (ConnectionDlg).


Please check your connection Creandetials .

  James H replied to elodie lodios
02-Nov-11 03:01 AM
If you are using the SQL Server Management Studio 2008 .Then you can't connect to the Lower Version.

“An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection. ….�?

http://www.linglom.com/images/howto/sqlServer/remote/a.png

“Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection.�?

http://www.linglom.com/images/howto/sqlServer/remote/b.png

To resolve these problems, you have 2 majors task. One is to enable both SQL Server and Windows authentication mode on SQL Server and the other is to allow remote connection and SQL Server Browser.

Step-by-step

  • Check that you have allowed both SQL Server and Windows Authentication mode (If you’re not use Windows Authentication mode). For instance, user ‘sa’.
    1. Login to SQL Server using SQL Server Management Studio Express on local SQL Server with Windows Authentication user. This will use Windows account to authenticate to SQL Server.
      Login using Windows authentication mode on local
    2. In Object Explorer, right click on the instance name and select Properties.
      Open SQL Server Properties
    3. On the left, select Security and change Server authentication to SQL Server and Windows Authentication mode. If the choice is already selected, that means you have already allowed SQL Server authentication.
      http://www.linglom.com/images/howto/sqlServer/remote/3.png
    4. There’ll be an information window shows that you need to restart SQL Server to takes effect of the changes.
      http://www.linglom.com/images/howto/sqlServer/remote/4.png
    5. Right-click on the instance name again, select Restart to restart SQL Server service.
      Restart SQL Server Service
    6. Select Yes.
      http://www.linglom.com/images/howto/sqlServer/remote/6.png
    7. Wait for service stop and start.
      http://www.linglom.com/images/howto/sqlServer/remote/7.png
    8. That’s it. You have enabled both SQL Server and Windows authentication so now you can login to SQL Server with your current Windows account or your created account.
  • Check that you have enabled remote connection on SQL Server Surface Area Configuration
    1. Open SQL Server Surface Area Configuration.
      http://www.linglom.com/images/howto/sqlServer/remote/8.png
    2. Select Surface Area Configuration for Services and Connections.
      http://www.linglom.com/images/howto/sqlServer/remote/9.png
    3. On the left side, expand your SQL Server instance -> Database Engine -> Remote Connections. On the right side, select Local and remote connections -> using both TCP/IP and named pipes.
      http://www.linglom.com/images/howto/sqlServer/remote/10.png
    4. On the left side, select SQL Server Browser -> Service.
      On the right side, if the startup type is Disable, you need to change to Automatic and click Apply and click Start button to start the service. Then, click OK.
      http://www.linglom.com/images/howto/sqlServer/remote/11.png
    5. You have finished configure. Now try to login to your SQL Server from remote computer using SQL Server authentication mode.
      Login to remote SQL Server
    6. Login to SQL Server succeeded.
      Login succeeded

Summary

  Web Star replied to elodie lodios
02-Nov-11 03:02 AM
http://support.microsoft.com/kb/946127
Visual Studio 2005 Support for SQL Server 2008, Community Technology Preview
http://www.microsoft.com/downloads/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&displaylang=en
  Vickey F replied to elodie lodios
02-Nov-11 03:03 AM
SSMS uses the .NET managed provider for SQL Server to communicate with SQL Server.  Enterprise Manager uses ODBC to do the same thing.

SSMS can only connect to SQL Server 2005 servers (including Express servers) and SQL Server 2000 servers (including SQL Server 2000 Desktop Engine servers).  If your server is actually a SQL Server 7.0 server or earlier, SSMS can't work with it, but SEM can.
  Web Star replied to elodie lodios
02-Nov-11 03:04 AM
you need to get your newer version SQL Server 9.0.3228 or higher, then it works. SQL Server Management Studios are only ever backwards compatible. They never work when connection to versions of the SQL server engine newer than the version they were designed to work with. Suggest updating management tools to version 2008.
  Reena Jain replied to elodie lodios
02-Nov-11 03:20 AM
hi,

It seems you have to download the full package to get the Management Studio. I remember that's how they did it with SQL 2000. If you wanted to have management studio on a client, you had to install client features from the server CD. The approach with Management Studio Express is a very welcome initiative. Let's hope they will keep it for 2008.

More info on the procedure can be found here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2512285&SiteID=1 


hope this will help you
  Riley K replied to elodie lodios
02-Nov-11 05:10 AM

The evidence points to the fact that your database engine is running as 2008 but you are using the SQL Server Management Studio from 2005. There is a way we can check this.


  1. On the Start Menu, go to your "Microsoft SQL Server" menu item (depending on what you installed, it may say 2005, 2008, or 2008 R2).
  2. Go to the "Configuration Tools" folder under that.
  3. Launch the "SQL Server Configuration Manager".
  4. Click on "SQL Server Services" in the left tree.
  5. Right-click on "SQL Server (SQLEXPRESS)" in the right pane, and then select "Properties".
  6. Click on "Advanced".
  7. Scroll down and look at the "Version". I have 2008 R2 installed, so my version is 10.50.1600.1. Look at your version and then compare it to one of the lists on the internet. Here is one: http://www.mytechmantra.com/LearnSQLServer/SQL_Server_Versions_P1.html.

If your version of SQL Express is 2005 and you have the 2005 Management Studio, then everything should work. But if your SQL Express version is 2008 and you want 2005, you'll have to uninstall the SQL Express instance and then attempt to reinstall SQL Server 2005 Express

I think finding out what version you have installed of the database engine will be a good next step in understanding what is happening.


Regards
Create New Account
help
SQL server 2000 SQL Server Does Microsoft still support SQL server 2000? SQL Server New Users Discussions SQL Server (1) SQL Server Books Online (1) SQL server
Attach SQL Server 2008 database to SQL Server 2000 Server SQL Server Hi, I have created a database in SQL Server 2008, with compatibility level of SQL
SSIS / DTS with SQL Server 2000? SQL Server I am working with a SQL Server 2005 client while the server still runs SQL Server 2000. SQL Server 2000 had DTS while 2005 has SSIS. Given
SQL Server 2000 SQL Server Are there any compatability issues with SQL Server 2000 Enterprise edition and Server 2003 standard with SP2? SQL Server Discussions SQL Server 2000 (1
Problem upgrade sql server 6.5 to sql server 2000 enterprise edition on Windows 2000 Server SQL Server Hello, I have problems with upgrade sql server 6.5 to sql server 2000