Problem connecting using Windows XP Professional

Greetings,

I installed SQL Express 2005 on my machine with XP Professional. My machine name is ROBERT and my user name is Rob. I did not get asked during the installation to supply an administrator password.

Following the installation when I try to connect using a C# app and setting IntegratedSecurity to true I get told that ROBERT\Rob is not authorised to connect to the database (paraphrased as I do not have the exact error message with me).

How do I go about adding my user name to the database if I do not know what the "sa" password is ?

Thanks,

Robert

Hi Robert...you are having trouble with your Windows user most likely because you are not a valid user on the server as of yet...by default, the only valid users on the server are members of the BUILTIN\Administrators group and the SQL service account(s) and the sa (if appropriate).

If you don't know the sa password, you'll have to get somebody who is either a member of the Administrators group or who knows the SQL service account password(s) to login and add your windows user as a valid server login and provide the appropriate permissions to the appropriate database(s).

Look for the following commands in SQL Books Online for more help there:

CREATE LOGIN...

CREATE USER...

HTH,