Manually configure Umbraco4.71 not using Sql Server CE
Hi
I try to manually install Umbraco4.71 to use SQL Server , I follow all the instructions to change the umbracoDbDSN to use my new server and database.It does not work , every time I browse to my site , it still go to the login page directly ,I assume it is still using sql server ce then, how can change this , any help would be much appreciated and plus what is the default user name and password for Umbraco4.71 using sql server ce ?
Do I understand correctly that your database was originally on CE and you are manually moving it to SQL Server (full)??
Check a couple of things...
Did you make a user on your SQL Server with "owner" permission on the umbraco database?
Are you able to log on to your SQL Server database via Management Studio with that user?
If you have problems with this, then there is something wrong with the user or schema in SQL Server. If you can log on ok, then it's a problem with your umbracoDbDSN (or some other config), in which case, I'd ask you to post your <connectionStrings> from web.config
Manually configure Umbraco4.71 not using Sql Server CE
Hi
I try to manually install Umbraco4.71 to use SQL Server , I follow all the instructions to change the umbracoDbDSN to use my new server and database.It does not work , every time I browse to my site , it still go to the login page directly ,I assume it is still using sql server ce then, how can change this , any help would be much appreciated and plus what is the default user name and password for Umbraco4.71 using sql server ce ?
Hi there,
Do I understand correctly that your database was originally on CE and you are manually moving it to SQL Server (full)??
Check a couple of things...
Did you make a user on your SQL Server with "owner" permission on the umbraco database?
Are you able to log on to your SQL Server database via Management Studio with that user?
If you have problems with this, then there is something wrong with the user or schema in SQL Server. If you can log on ok, then it's a problem with your umbracoDbDSN (or some other config), in which case, I'd ask you to post your <connectionStrings> from web.config
Hope that gives you some clues.
Lesley
is working on a reply...