SQL Server 2005 & .MDF Files
-
Hi everybody. I'm more of a c# kinda guy so not all that well up with the hard core sql stuff. The problem I have is I have recently uninstalled all instances of SQL Server off my machine. Then I installed SQL Server 2005, and found that my web applications which relied on SQL express stopped working :doh: So I went to microsoft, and downloaded Express 2005 which did not do the trick. (it tells me it cant start up a user instance) Anyhoo, this upset me somewhat, and as much as I play about with permissions and settings for express I just can't get it working. So, I think it would be better to ship all my .MDF files into real sql server which would be better anyway, but I cant find how to do this... Please can somebody help???? Is it actually possible??? Thanks in advance. (sorry about the rambling story...)
-
Hi everybody. I'm more of a c# kinda guy so not all that well up with the hard core sql stuff. The problem I have is I have recently uninstalled all instances of SQL Server off my machine. Then I installed SQL Server 2005, and found that my web applications which relied on SQL express stopped working :doh: So I went to microsoft, and downloaded Express 2005 which did not do the trick. (it tells me it cant start up a user instance) Anyhoo, this upset me somewhat, and as much as I play about with permissions and settings for express I just can't get it working. So, I think it would be better to ship all my .MDF files into real sql server which would be better anyway, but I cant find how to do this... Please can somebody help???? Is it actually possible??? Thanks in advance. (sorry about the rambling story...)
Hi,
Unsy wrote:
it tells me it cant start up a user instance
Have you had a look ath this: http://msdn.microsoft.com/en-us/library/ms143684(SQL.90).aspx[^]. If I remember correctly, user instanes aren't allowed by default, so you may need to use
sp_configureto change the setting.Unsy wrote:
, I think it would be better to ship all my .MDF files into real sql server which would be better anyway, but I cant find how to do this...
That's possible. Basically SQL Server Standard and Express Editions have the same codebase. Express has just some limitations. I'm just wondering why you use user instances. User instance is run in the users account who makes the connection. You could also use normal instance and have the database running all the time and your web application could connect to that. It could make things simpler (administration, backups etc) Mika
The need to optimize rises from a bad design.My articles[^]
-
Hi,
Unsy wrote:
it tells me it cant start up a user instance
Have you had a look ath this: http://msdn.microsoft.com/en-us/library/ms143684(SQL.90).aspx[^]. If I remember correctly, user instanes aren't allowed by default, so you may need to use
sp_configureto change the setting.Unsy wrote:
, I think it would be better to ship all my .MDF files into real sql server which would be better anyway, but I cant find how to do this...
That's possible. Basically SQL Server Standard and Express Editions have the same codebase. Express has just some limitations. I'm just wondering why you use user instances. User instance is run in the users account who makes the connection. You could also use normal instance and have the database running all the time and your web application could connect to that. It could make things simpler (administration, backups etc) Mika
The need to optimize rises from a bad design.My articles[^]
-
Hi Mika Thank you for your help. I have fixed my problem by simply attaching the MDF files to SQL 2005 which gives me the usual SQL server control and its on constantly. Thanks again... :-D