re: northwind and pub database install help needed

[cbrown777]

I have looked at a number of scripting info on how to install the sample northwind and pub databases and need help. I already have the mdf and ldf files downloaded.
The scripting file on the internet says to run the following command:

osql -E -Q "exec sp_attach_db @dbname=N'Northwind',
@filename1=N'C:\path\northwind.mdf',
@filename2=N'C:\path\northwind.ldf'"

I get errors when I submit this command. My error is login failed for user "my pc name"

Any help would be appreciated

 

[mrdenny]

Sounds like you didn't give your self admin rights to the SQL server on your machine. Is the SQL Server installed on your workstation or on a server? What is the exact error message?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com