Solved

Create Login script to the server

Posted on 2008-10-15
5
3,384 Views
Last Modified: 2008-10-15
I am trrying to create logins to a few database servers, i tried two scripts, some of them work on  a particualr server while the second works on some servers.

here are the scripts

USE [master]
GO
if not exists(select * from sys.server_principals where name = ABC\apps_dev')
begin
      CREATE LOGIN [ABC\apps_dev] FROM WINDOWS
end
GO

It gives me an error on some database servers
Line 3: Incorrect syntax near 'LOGIN'.

I tried this on the server it fails  and this works on some server
USE [master]
GO
if not exists(select * from syslogins where name = 'ABC\apps_dev')
begin
      exec sp_grantlogin 'ABC\apps_dev'
end
GO

I would like to know why these versions work on some servers, is this a versioning issue and how can I verify which version is used.

0
Comment
Question by:countrymeister
  • 3
5 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22722096
create login only works on sql 2005
won't work on sql 2000
0
 
LVL 1

Author Comment

by:countrymeister
ID: 22722300
momi_sabaq

How can I verify the version of the database server
0
 
LVL 13

Expert Comment

by:devsolns
ID: 22722342
You have to use the syntax below for SQL SERVER 2000:

EXEC sp_grantlogin 'Corporate\Test'
EXEC sp_addlogin 'test','hello'

See this link:
http://support.microsoft.com/kb/325003
0
 
LVL 13

Accepted Solution

by:
devsolns earned 250 total points
ID: 22722352
To Get the version:
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
0
 
LVL 13

Expert Comment

by:devsolns
ID: 22722380
See this link to match the product versions to what you have returned from the query above:

http://support.microsoft.com/kb/321185
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now