Post reply

SQL Server 2005 connection problem

  • March 21, 2006 at 9:39 am

    #627920

    Well I just applied a couple more users with sql authentication and that seems to work locally as before. Actually when I acreate the Login user - I can only apply windows OR sql authentification in the express edition (in comparison to sql server 2005). However, I do have local and remote connections checked on the sql surface are tool.

    This could be a point that I have rather stupidly overlooked in the express version. However in the Express version 2005 there doesn't seem to be anywhere where I can set mixed mode. Do you know differently? I know that in the non express version this is possible.

    Other than I will recheck my connection string.

    Thanks very much for your help...

  • March 21, 2006 at 9:59 am

    #627930

    I just looked at your previos message:

    go to 2005 server management studio, right click on the server,choose properties and then click on security - ensure it is set to windows and sql authentication mode

    - but the mixed mode is selected

  • March 22, 2006 at 4:00 am

    #628043

    Oliver, you appear to be confused about a number of issues so I suggest we get things nice and simple first.

    Forget remote connections, let's get an SQL login working through SSMS locally. Run this:

    CREATE LOGIN testuser WITH PASSWORD = '3KHJ6dhx(0xVYsdf'

    GO

    Try entering those details when you connect *locally* with SSMS and post the result.

  • March 22, 2006 at 4:34 am

    #628047

    Oh I love it when things are nice and simple.

    OK, I executed the query and got the result:

    "Command(s) completed successfully."

    I am able to connect with the given values locally with mssql server. So first step accomplished, now for the remote stage.

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply