I have a problem with Microsoft SQL Server 2005 Express,
My web application runs fine on my development PC, but when I copy it to my
server (My server is running Windows 2000 Server) and try to access it from
the web I get following error:
An attempt to attach an auto-named database for file
C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
same name exists, or specified file cannot be opened, or it is located on UN
C
share.
The ASPNET account has full control of the database.
Is this a known bug in Microsoft SQL Server?
What should I do?
Thanks for your help in advance,
Noah.Noah
How do you perform an attach operation?
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||Assuming you are using the default settings, the .mdf and .ldf files must be
located in the same directory as your application on the server. The other
common cause for this is having the database open in the IDE or having the
database files with no write permissions for the ASPNET account. There is
more info here:
http://msdn.microsoft.com/sql/expre...expuserinst.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
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||I use the following command:
data source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDire
ctory|aspnetdb.mdf;User Instance=tru
e
"Uri Dimant" wrote:
> Noah
> How do you perform an attach operation?
>
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>
>|||As I said... The ASPNET account has full control of the database and of the
application root folder.
Read, Write, Modify, etc.
I thought that was the problem, but it isn't. I had already given the ASPNET
account full control when I had problems with a hit counter. That took me tw
o
days to figure out...
Anyway,
With the info you have now what do you suggest I do?
Thanks,
Noah.
"Roger Wolter[MSFT]" wrote:
> Assuming you are using the default settings, the .mdf and .ldf files must
be
> located in the same directory as your application on the server. The othe
r
> common cause for this is having the database open in the IDE or having the
> database files with no write permissions for the ASPNET account. There is
> more info here:
> http://msdn.microsoft.com/sql/expre...expuserinst.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
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>
>|||So, you eliminated one of the three things I suggested. How about the other
two? Di reading the article give you any things to try?
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
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...[vbcol=seagreen]
> As I said... The ASPNET account has full control of the database and of
> the
> application root folder.
> Read, Write, Modify, etc.
> I thought that was the problem, but it isn't. I had already given the
> ASPNET
> account full control when I had problems with a hit counter. That took me
> two
> days to figure out...
> Anyway,
> With the info you have now what do you suggest I do?
> Thanks,
> Noah.
> "Roger Wolter[MSFT]" wrote:
>|||Yes.
"Roger Wolter[MSFT]" wrote:
> So, you eliminated one of the three things I suggested. How about the oth
er
> two? Di reading the article give you any things to try?
> --
> 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
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
>
>
No comments:
Post a Comment