locked
How can I connect my database to SQL 2005 express? RRS feed

  • Question

  • Hi,

    I have a Vista Home. I have an SQL Server 2005 Express. I have an SQL Server Management Studio Express. We have tried everything.
    How can I connect my database to SQL 2005 express?


    Datasorce Administrator(ODBC)  >>>>user DSN>>>>SQL sever
         Create a new data source to SQL server:  MS SQL Server DSN settings:>>>>  ok, ok, it found the my computer.
         How should SQL Server verify the authenticity of the login ID?  >>>>>With SQL server authentication
                                                                                                                          >>>> Login ID: sa
                                                                                                                          >>>>Password:  empty(May I need Password?)
        
                                                                                                 >>>>>>I tried the other option.( Windows NT authentication)
                                                                                                                   there is a place to test the connection. It looks ok, but not ok.

    Ansvere: connection failed:
    SQL State:'28000'
    SQL Server hiba:18452
    [Micrsosoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'sa'. The user is not associated with the trusted SQL Server conncetion.



    Please help!

    Thanks

    Lollek
    Friday, May 22, 2009 6:54 PM

Answers

  • No need to resintall. Either install SQL Server Express Management Studio or set the appropiate value through the registry as mentioned in:

    http://support.microsoft.com/kb/285097

    -Jens
    Jens K. Suessmeyer http://blogs.msdn.com/Jenss
    Saturday, May 23, 2009 8:10 AM
  • Hello,

    SSMS = SQL Server Management Studio ( complete version only available with not-free SQL Server Editions : Workgroup/Standard/Developer/Entreprise )
    SSMSEE = SQL Server Management Studio Express Edition : light edition of SSMS ( only for SQL Server 2005 Express Edition )
    SSMSE  = SQL Server Management Studio Express : ligth edition of SSMS ( only for SQL Server 2008 Express Edition )

    Remark : SSMSEE has been released too quickly so it is not possible to upgrade it to the SSMSE ( uninstall SSMSEE before the install of SSMSE or the install/upgrade to SQL Server 2008 Express Edition )

    It is usual to speak about SSMS instead SSMSEE or SSMSE because these programs are very similar ( except that the express editions cannot manage features which are specific to not-free editions, like clusters and so on )

    If you have a SSMSEE (2005) with the same Service Pack (SP) than your SQL Server instance,you have not to reinstall your SQL Server Express.
    You will find SSMSEE in the group of Microsoft SQL Server Express 2005 ( Start ==> All programs )

    And you follow the way given by Jens to modify your Server Authentification

    Don't hesitate to post again for more help or explanations

    Have a nice day

    PS : while rereading your original post , you ask whether you should provide a password for sa : YES as sa has the whole rights/permissions on your instance or your database and it is a well-known security gap created by beginners ( and exploited by hackers ).
    To modify the password of "sa", could you have a look on this link ?
    http://support.microsoft.com/kb/322336/en-us
    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
    Saturday, May 23, 2009 8:15 AM

All replies

  • Seems that SQL Server authorization is disabled. Either use windows authentication or enable SQL Server authentication.
    Friday, May 22, 2009 7:35 PM
  • Thanks Florian,

    I'm not advanced user (unfortunately). Where can I set it?

    Thanks

    Lollek
    Friday, May 22, 2009 7:55 PM
  • Open SSMS > Ricght click the Server you want to administer > Properties > Security > Server Authentication > Click the mixed option (SQL Server and Windows authentication). make sure you restart the service to apply the changes.

    -Jens
    Jens K. Suessmeyer http://blogs.msdn.com/Jenss
    Friday, May 22, 2009 9:39 PM
  • Hi Jens,

    For this I need to reinstall the SQL 2005 Express? If not what is the path to SSMS?

    Thanks
    Saturday, May 23, 2009 7:24 AM
  • No need to resintall. Either install SQL Server Express Management Studio or set the appropiate value through the registry as mentioned in:

    http://support.microsoft.com/kb/285097

    -Jens
    Jens K. Suessmeyer http://blogs.msdn.com/Jenss
    Saturday, May 23, 2009 8:10 AM
  • Hello,

    SSMS = SQL Server Management Studio ( complete version only available with not-free SQL Server Editions : Workgroup/Standard/Developer/Entreprise )
    SSMSEE = SQL Server Management Studio Express Edition : light edition of SSMS ( only for SQL Server 2005 Express Edition )
    SSMSE  = SQL Server Management Studio Express : ligth edition of SSMS ( only for SQL Server 2008 Express Edition )

    Remark : SSMSEE has been released too quickly so it is not possible to upgrade it to the SSMSE ( uninstall SSMSEE before the install of SSMSE or the install/upgrade to SQL Server 2008 Express Edition )

    It is usual to speak about SSMS instead SSMSEE or SSMSE because these programs are very similar ( except that the express editions cannot manage features which are specific to not-free editions, like clusters and so on )

    If you have a SSMSEE (2005) with the same Service Pack (SP) than your SQL Server instance,you have not to reinstall your SQL Server Express.
    You will find SSMSEE in the group of Microsoft SQL Server Express 2005 ( Start ==> All programs )

    And you follow the way given by Jens to modify your Server Authentification

    Don't hesitate to post again for more help or explanations

    Have a nice day

    PS : while rereading your original post , you ask whether you should provide a password for sa : YES as sa has the whole rights/permissions on your instance or your database and it is a well-known security gap created by beginners ( and exploited by hackers ).
    To modify the password of "sa", could you have a look on this link ?
    http://support.microsoft.com/kb/322336/en-us
    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
    Saturday, May 23, 2009 8:15 AM