Using SQL express with WSS 3.0 - Rand |
17-Jan-07 09:33:02
|
well; i did some fiddling today to see if i installed wss 3 on a server and
let it install WID, if i could UPGRADE to sql 2005 standard. the long and
short of it was NO, i couldn't upgrade the NAMED instance. i received an
error message that essentially indicated that i could not upgrade the named
instance since the name was 'reserved'... likely because the MICROSFT##SSEE
name (or whatever it was called) is reserved for wss v 3...ergo it will not
allow you to have a sql 2005 standard instance named the same thing...
also, after sql 2005 std was installed, i tried to connect to the
MICROSOFT##SSEE instance and received an error message: "An error has
occurred while establishing a connection to the server. when connecting to
SQL Server 2005, this failure may be caused by te fact that under the default
settings SQL server does not allow remote connections. (provider: SQL NETwork
interfaces, error 26- Error Locating Server/Instance specified) (Microsoft
Server)".... so it seems that the MICROSOFT##SSEE instance of sql installed
by WID DOES NOT permit connections by the sql 2005 server management
studio....
so still... anyone have any idea if you can change the location of the
database files in WID? and if so, what are the commands to do so? |
 |