• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 917
  • Last Modified:

SQL 2005 Database owner woes...

I recently had to install a copy of SQL 2005 Std.  They software company I had to install if for required a special collation so after speaking with Microsoft they gave me the following command line to install it:
Start /wait <optical drive letter>:\servers\setup.exe /qb INSTANCENAME=<instance name> ADDLOCAL=All PIDKEY=<Product ID without -> SAPWD=<StrongPassword> SQLACCOUNT="NT AUTHORITY\SYSTEM" AGTACCOUNT="NT AUTHORITY\SYSTEM" SQLBROWSERACCOUNT="NT AUTHORITY\SYSTEM" ASACCOUNT="NT AUTHORITY\SYSTEM" RSACCOUNT="NT AUTHORITY\SYSTEM" SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

After doing this it made my account the DB_owner account. I am being told by the aoftware company I should have the SA account as the DB_Owner account. They gave me the following script to change the owner:
USE <iVantage database name>
EXEC sp_changedbowner 'sa'
GO

After running this script I get the following error message:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '<'.

I checked and found the server authentication is set to both SQL and windows.

ANy help would be greatly apperciated as I am a newbie to SQL 2005!
0
dgerbergss
Asked:
dgerbergss
  • 2
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
u should replace the cotents incuded in the <> . for example if your database name is DBTest , the query should be like

USE DBTest
EXEC sp_ChangeDBOwner 'sa'
0
 
dgerbergssAuthor Commented:
I did and it fails w/ sa in it.
0
 
dgerbergssAuthor Commented:
Sorry I did cahnge the < > section to the actual database name and it failed.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
did u removed the <>, u neerd to do it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now