January 30, 2012 at 3:38 pm
I am a new student at a local college and I have been taking Database /SQL to get my cert in SQL SERVER 2008 R2. The instructor wants us to use SQL EXPRESS, SO, I downloaded it from the MSN downloads website. I took the full download...with Visual Studio tools. Setup went successful. I have used and build database in DB2 and SQL so I know how to set up sa grants for myself and can use both Windows and SQL SERVER Authentication
We are using the Murach's student books, with the http://www.murach.com databases I downloaded those as well, but have been having troubles with attaching the files to SQLEXPRESS.
I tried using the Batch Scripts they provided, nothing worked.
I tried using the SQL Server Database rightclick attach method and chosing 1 database file . same results.
Here is the error I keep getting can you help me.
Thank-you
Patty
-------------------------------------------------------------------------------------------
attach database failed for Server 'PATTY-HP\SQLEXPRESS'. (Microsoft.SqlServer.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1617.0+((KJ_RTM_GDR).110422-1125+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.Attach()
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SendDataToServer()
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Server.AttachDatabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)
===================================
Unable to open the physical file "C:\Databases\AP.mdf". Operating system error 5: "5(Access is denied.)". (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1617&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476
------------------------------
Server Name: PATTY-HP\SQLEXPRESS
Error Number: 5120
Severity: 16
State: 101
Line Number: 1
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
January 30, 2012 at 5:09 pm
Hi!
it seems your having trouble with account issue. GO to SQLExpress propoerties. Change built in account from network to local system.
SQL Server Config Manager --> select sqlserver2005 --> right click on server node.. voila..
===============================================================
"lets do amazing" our company motto..
January 30, 2012 at 9:04 pm
Even if this is a SS2008 version
January 30, 2012 at 9:20 pm
I need alittle more information since I cannot find the SQLEXPRESS Connection Mgr in the Properties window. But I did notice the Operation System is Window NT 6.1, when I am running Windows 7 Home Premium Ed. (64-bit) and the platform SS2008 has me listed is NT INTEL X86 - Does this matter?
January 31, 2012 at 5:54 am
😀
run SQL Server Configuration Manager, select the SQL Server 2005 services node... in the right pane select the SQL Server engine you want to manage and rx click.. "Properties"..
============================================
Hello! I hate to bring this up again but this doesn't seem to work for me. I change network service to local system in Properties and still not able to start server because I don't have admin rights. So I try to grant administrative rights to myself using SQL Surface Area Configuration but it gives me next error
TITLE: .Net SqlClient Data Provider
------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
OK. So I enable remote connection using both TCP/IP and named pipes (also with SQL Surface Area Configuration) and still get error. When following help link it advices to make sure Server Browser is started! But I can not start it without admin rights! Loop?))
Please show me what am I missing
January 31, 2012 at 6:02 am
:w00t:
Sorry i forget to post you Articles links such as
http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/1af86717-8fcf-4e2d-bf29-70fb5fae1bfb
http://social.msdn.microsoft.com/Forums/eu/sqlexpress/thread/f653ea71-c514-46d8-83a6-cd2ef0a872d8
February 2, 2012 at 5:56 am
2005 and 2008 are pretty much the same.. 🙂
===============================================================
"lets do amazing" our company motto..
February 2, 2012 at 2:49 pm
Ok. Thanks for all your help. But my SQL Server 2008 Instructor found the solution - it was when I downloaded the murach book example databases that caused the issue. I had to go to the folder after it was unzipped and use the folder advanced priorities setting and modify all users to Full SA Mode. After I finished it worked I can attach, detach, etc. I love SQL. Its so much easier than DB2. It's like DB2 for dummies!!! 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply