Can I use SQL Express database inside full blown SQL 2005?

Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
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
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?|||It does not work saying "The user instance login flag is not supported on th
is version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message new
s:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
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
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?|||You will have to take the User Instance flag out of your connections strings
, attach the database to the production system and then establish users and
permissions in the production system.
There's some discussion of converting to User Instance to normal connections
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
"GS" <nospam@.nowhere.com> wrote in message news:ucH0y7SHGHA.3916@.TK2MSFTNGP1
0.phx.gbl...
It does not work saying "The user instance login flag is not supported on th
is version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message new
s:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
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
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?