|
|
You're in the
sql server msde
group:Attach to SQL Server 2K5 Express Problem
sql server msde:
[quoted text, click to view] Phill wrote: > I am building a web app using VS 2K5 with SQL Server Express as the > backend. The project and database are stored in the default location: > My Documents\Visual Studio 2005\WebSites\MyWebSiteName. I also > downloaded and installed the SQL Server Management Studio Express to > be able to manage the database. The problem I have is that I am > unable to attach the database. I go through the process but the > SSMSE won't allow me to navigate to where my database is. I'm > needing to import a table with a lot of data. Is this a bug? Do I > need to temporarily move my database file? Thanks. I do not currently have VS2005 installed, but with SSMSE I was able to navigate to My Documents\Visual Studio 2005\WebSites\MyWebSiteName (the \WebSites\MyWebSiteName folders have been actually created by me as, again, I do not have VS2005 installed on that machine) both with a windows administrator member (trusted connections) and the "traditional" "sa" SQL Server login (mixed mode security) I do not think VS2005 sets some sort of particular ACLs for that folder, but I can be wrong here.. the account running my SQLExpress instance is LocalSystem.. -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
I am building a web app using VS 2K5 with SQL Server Express as the backend.
The project and database are stored in the default location: My Documents\Visual Studio 2005\WebSites\MyWebSiteName. I also downloaded and installed the SQL Server Management Studio Express to be able to manage the database. The problem I have is that I am unable to attach the database. I go through the process but the SSMSE won't allow me to navigate to where my database is. I'm needing to import a table with a lot of data. Is this a
When you created the database in that location, you probably did it as a
user instance because that's the Visual Studio default. The user running Visual Studio has permissions to that directory because he created it. You are now trying to attach it to the main SQL Server instance instead of the user instance, The main SQL Express instance is running as Network Service and more than likely does not have permissions to open files in you application directory. You can get around this by giving Network Service read-write permission on the database and log files. Be aware that while the files are attached to the main instance, your application using the user instance connection will not be able to access them. Check this article for an explanation of user instances: http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp -- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm [quoted text, click to view] "Phill" <Phill@discussions.microsoft.com> wrote in message news:1CF63F8E-902B-4AD7-A2F8-B7DA7233D7AE@microsoft.com... >I am building a web app using VS 2K5 with SQL Server Express as the >backend. > The project and database are stored in the default location: My > Documents\Visual Studio 2005\WebSites\MyWebSiteName. I also downloaded > and > installed the SQL Server Management Studio Express to be able to manage > the > database. The problem I have is that I am unable to attach the database. > I > go through the process but the SSMSE won't allow me to navigate to where > my > database is. I'm needing to import a table with a lot of data. Is this a > bug? Do I need to temporarily move my database file? Thanks.
Thanks, I am now able to connect to the database. It didn't really do me any
good though. I want to import an Access table into it but there aren't any tools to do so. No ODBC drivers, nothing. So how are we supposed to import data into SSE2K? Thanks. [quoted text, click to view] "Roger Wolter[MSFT]" wrote:
> When you created the database in that location, you probably did it as a > user instance because that's the Visual Studio default. The user running > Visual Studio has permissions to that directory because he created it. You > are now trying to attach it to the main SQL Server instance instead of the > user instance, The main SQL Express instance is running as Network Service > and more than likely does not have permissions to open files in you > application directory. You can get around this by giving Network Service > read-write permission on the database and log files. Be aware that while > the files are attached to the main instance, your application using the user > instance connection will not be able to access them. > > Check this article for an explanation of user instances: > > http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp > > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > Use of included script samples are subject to the terms specified at > http://www.microsoft.com/info/cpyright.htm > > "Phill" <Phill@discussions.microsoft.com> wrote in message > news:1CF63F8E-902B-4AD7-A2F8-B7DA7233D7AE@microsoft.com... > >I am building a web app using VS 2K5 with SQL Server Express as the > >backend. > > The project and database are stored in the default location: My > > Documents\Visual Studio 2005\WebSites\MyWebSiteName. I also downloaded > > and > > installed the SQL Server Management Studio Express to be able to manage > > the > > database. The problem I have is that I am unable to attach the database. > > I > > go through the process but the SSMSE won't allow me to navigate to where > > my > > database is. I'm needing to import a table with a lot of data. Is this a > > bug? Do I need to temporarily move my database file? Thanks. > >
Use the upsizing Wizard in access to push the data into SSE
-- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm [quoted text, click to view] "Phill" <Phill@discussions.microsoft.com> wrote in message news:F00DFB95-4D36-47CC-9A46-41A5A3577D60@microsoft.com... > Thanks, I am now able to connect to the database. It didn't really do me > any > good though. I want to import an Access table into it but there aren't > any > tools to do so. No ODBC drivers, nothing. So how are we supposed to > import > data into SSE2K? Thanks. > > "Roger Wolter[MSFT]" wrote: > >> When you created the database in that location, you probably did it as a >> user instance because that's the Visual Studio default. The user running >> Visual Studio has permissions to that directory because he created it. >> You >> are now trying to attach it to the main SQL Server instance instead of >> the >> user instance, The main SQL Express instance is running as Network >> Service >> and more than likely does not have permissions to open files in you >> application directory. You can get around this by giving Network Service >> read-write permission on the database and log files. Be aware that while >> the files are attached to the main instance, your application using the >> user >> instance connection will not be able to access them. >> >> Check this article for an explanation of user instances: >> >> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp >> >> >> -- >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> Use of included script samples are subject to the terms specified at >> http://www.microsoft.com/info/cpyright.htm >> >> "Phill" <Phill@discussions.microsoft.com> wrote in message >> news:1CF63F8E-902B-4AD7-A2F8-B7DA7233D7AE@microsoft.com... >> >I am building a web app using VS 2K5 with SQL Server Express as the >> >backend. >> > The project and database are stored in the default location: My >> > Documents\Visual Studio 2005\WebSites\MyWebSiteName. I also downloaded >> > and >> > installed the SQL Server Management Studio Express to be able to manage >> > the >> > database. The problem I have is that I am unable to attach the >> > database. >> > I >> > go through the process but the SSMSE won't allow me to navigate to >> > where >> > my >> > database is. I'm needing to import a table with a lot of data. Is >> > this a >> > bug? Do I need to temporarily move my database file? Thanks. >> >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |