Skip to main content
Database Administrators

Return to Question

edited tags
Link
Yasir Arsanukayev
Yasir Arsanukayev
  • 3.2k
  • 3
  • 22
  • 30
deleted 40 characters in body; edited title
Source Link
Aaron Bertrand
Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619

How to create new users for restored database as SAdatabases?

We are using SQL Server 2008. I am not too familiar with itSQL Server and am facing the following problem: The server was freshly installed and the only existing rolelogin is the SAsa.

Then a couple of databases were restored from earlier backups.

Now I'd like to run a few SQL scripts that create new users for these databases, running as sa, but am getting the message that I am not allowed to do this (as SA).

Any hints? Thanks all.

How to create new users for restored database as SA?

We are using SQL Server 2008. I am not too familiar with it and am facing the following problem: The server was freshly installed and the only existing role is the SA.

Then a couple of databases were restored from earlier backups.

Now I'd like to run a few SQL scripts that create new users for these databases, but am getting the message that I am not allowed to do this (as SA).

Any hints? Thanks all.

How to create new users for restored databases?

I am not too familiar with SQL Server and am facing the following problem: The server was freshly installed and the only existing login is sa.

Then a couple of databases were restored from earlier backups.

Now I'd like to run a few SQL scripts that create new users for these databases, running as sa, but am getting the message that I am not allowed to do this.

Product is officially called "SQL Server" - neither MSSQL, nor MS SQL, nor MS-SQL or anything like that....
Source Link
marc_s
marc_s
  • 9k
  • 6
  • 45
  • 52

We are using MS SQL Server 2008. I am not too familiar with it and am facing the following problem: The Serverserver was feshlyfreshly installed and the only existing role is the SA.

Then a couple of databases were restored from earlier backups.

Now I'd like to run a few SQL scripts that create new users for these databases, but am getting the message that I am not allowed to do this (as SA).

Any hints? Thanks all.

We are using MS SQL 2008. I am not too familiar with it and am facing the following problem: The Server was feshly installed and the only existing role is the SA.

Then a couple of databases were restored from earlier backups.

Now I'd like to run a few SQL scripts that create new users for these databases, but am getting the message that I am not allowed to do this (as SA).

Any hints? Thanks all.

We are using SQL Server 2008. I am not too familiar with it and am facing the following problem: The server was freshly installed and the only existing role is the SA.

Then a couple of databases were restored from earlier backups.

Now I'd like to run a few SQL scripts that create new users for these databases, but am getting the message that I am not allowed to do this (as SA).

Any hints? Thanks all.

Source Link
DotNetDeveloper
DotNetDeveloper
  • 381
  • 1
  • 4
  • 13