InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 05:10:23 GMT20http://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxHey thanks for that, have been trawling for ages to find this code. Very useful. :-)Sat, 02 Mar 2013 18:22:13 GMTdeveloper 34412http://www.sqlservercentral.com/Forums/Topic964028-324-1.aspx(edit)sorry posted reply to wrong thread.Wed, 18 Aug 2010 06:47:18 GMTphil 78969http://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxthanks for all your help. I've learnt alot from you;-)Thu, 05 Aug 2010 07:55:34 GMTniteshrajgopalhttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxIt is correct.Thu, 05 Aug 2010 07:47:14 GMTSudeeptahttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxHi again,I've added the followinbg to my script[code="sql"]USE [master]IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE [name] = 'Reality')BEGIN-- Create user for SQL Authentication CREATE LOGIN Reality WITH PASSWORD = 'Games12er' ,DEFAULT_DATABASE = [Games] -- Add User to first database USE Games; CREATE USER Reality FOR LOGIN Reality; EXEC sp_addrolemember 'db_datareader', 'Reality' EXEC sp_addrolemember 'db_datawriter', 'Reality' END[/code]I figured it is easier to use sql authentication. Please advise me if this is correct. it seems to have worked on my pc. still have to test on a users pcThu, 05 Aug 2010 07:13:42 GMTniteshrajgopalhttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspx[quote]Is there anyway to get the account info of the user logged into windows in sql server?[/quote]You can not logged in to SQL Server, until you have a vaild login for the SQL Server instance. An user logged in to the Windows machine(using his Windows Login account), needs to have his windows login added to the SQL server before he can access the SQL instance. Is that what you are asking.Sorry, if I didn't understand your requirement.Thu, 05 Aug 2010 05:32:12 GMTSudeeptahttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxsorry but i'm a bit lost. Is there anyway to get the account info of the user logged into windows in sql server?Maybe I should tackle this differently. What do you think is an easire way to get around my problemThu, 05 Aug 2010 05:20:30 GMTniteshrajgopalhttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxIf the Windows account is already exist on your system, then you can use the above script to add it to SQL Server, and assign the required permissions.Thu, 05 Aug 2010 04:52:27 GMTSudeeptahttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxHi again,if I remember correctly there is a check box that asks if you want to add the user to logins as they are not added by default.Thing is i'm using a vb.net class to do the install so I have to set the login in my script.Thu, 05 Aug 2010 04:45:03 GMTniteshrajgopalhttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspx[quote][b]niteshrajgopal (8/5/2010)[/b][hr]say my PC Name is NITESH-PC. When I installed sql express it added NITESH-PC\NITESH to the logins. [/quote]It means you logged on to your PC with the user account NITESH. during the installation, you have added this account to the SQL Server Login.[quote]so if I was installing on a PC called TEST-PC with user TEST I would want to create a login in sql server as TEST-PC\TEST. is this possible?[/quote] Yes, you can add the account with the above script. However, if I remember correctly, the account using which you are installing the SQL Server 2005 Express edition, should be added as a login for the SQL instance.Thu, 05 Aug 2010 04:29:43 GMTSudeeptahttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxsay my PC Name is NITESH-PC. When I installed sql express it added NITESH-PC\NITESH to the logins.I need to create a login for the user that is installing sql server. so if I was installing on a PC called TEST-PC with user TEST I would want to create a login in sql server as TEST-PC\TEST. is this possible?Thu, 05 Aug 2010 04:18:59 GMTniteshrajgopalhttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxYou can not create a Windows Login account using the above script. You need to create the Windows Account using Computer Management (Start --> Run --> Compmgmt.msc). Expand Users & Computers, Clilck on User, Right click and create User, say you created a user named 'User1'.Then you can execute the above script, by replacing the login and user name as [test-pc\User1]Hope, this may help.Thu, 05 Aug 2010 03:59:10 GMTSudeeptahttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxthanks alot. That's exactly what I was looking for;-). How can I get the Windows User Name for example I want the user to be created like this:SQL Server Name\User Name.if I run that script you gave me will it solve my issue?Thu, 05 Aug 2010 02:33:51 GMTniteshrajgopalhttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxYou actually need two credentials, one to connect to the SQL Server instance (Login) and one to connect to the database (User).If you are using Windows Authentication to connect to the instance, then you can use the following command:[code="sql"]USE [master]GOCREATE LOGIN [test-pc\TestUser] FROM WINDOWS;GOUSE [TestDB]GOCREATE USER [test-pc\TestUser] FOR LOGIN [test-pc\TestUser] GO-- The following command will grant db-owner rights for the above userEXEC sp_addrolemember 'db_owner', [test-pc\TestUser] ;GO[/code]Hope, this may help.Thu, 05 Aug 2010 02:02:11 GMTSudeeptahttp://www.sqlservercentral.com/Forums/Topic964028-324-1.aspxHi Guys,I have a class that checks if sql server express 2005 is installed on a pc and if not it installs it. In my class I specify stuff like sa password etc for the install.When a user installed the software the database was created but he can't login as he gets a meesage saying:[quote]unhandled exception has occurred in your application. Cannot open database "Games" requested by the login. The login failed.[/quote]How can I create a user for my database programmatically. Or even I run a sql script that creates the database. How can I do this in the script.I'm just installing on a single pc, no networking required, so in my connectionstring I use .\SQLExpress as the server. please helpThu, 05 Aug 2010 01:25:37 GMTniteshrajgopal