I try to run my umbraco site on IIS 7.5, but I the site can't load. Everytime I try to nevigate to the site I see the following error in the event viewer:
Type 'umbraco.DataLayer.SqlHelperException' in Assembly 'umbraco.DataLayer, Version=0.3.0.0, Culture=neutral, PublicKeyToken=null' is not marked as serializable
I searched for a solution and I found suggestions to check the connection string. I checked and it's OK.
Try change the named pipe "win-sql" to the correct ip-adress. Or maybe add : Trusted_Connection=False; to the connectionsstring, or use "Data Source=WIN-SQL;Initial Catalog=Megalim;User Id=megalimnew;Password=pwd;
The console app u testet with, did u run the test on the sqlserver, or on the webserver ?
And the sql server dont have an instance name ? ex WIN-SQL\Sqlexpress ?
I ran the test on the web server(with every suggested connection string)
"Data Source=Win-SQL;Initial Catalog=Megalim;Trusted_Connection=False;User Id=megalimnew;Password=pwd" connects successfuly, but I still get the error...
umbraco 4.0.4 on IIS 7.5
Hi,
I try to run my umbraco site on IIS 7.5, but I the site can't load. Everytime I try to nevigate to the site I see the following error in the event viewer:
Type 'umbraco.DataLayer.SqlHelperException' in Assembly 'umbraco.DataLayer, Version=0.3.0.0, Culture=neutral, PublicKeyToken=null' is not marked as serializable
I searched for a solution and I found suggestions to check the connection string. I checked and it's OK.
(The site ran well on IIS 6 befor)
Help?
Hi Ben
What version of the .NET framework is the app pool for the site running? Think it should be 2.0 if I'm not mistaken.
/Jan
I also suspect that the application pool should be run in the classic mode.
Yes it should indeed run classic mode...how could I forget..#h5is.
/Jan
Thank you all for your help.
The application pool is 2.0 and the pipline mode is classic, but I still get the same exception error message..
Any other suggestions?
if its a 64bit OS, remember to allow 32 bit application under advanced settings for the app-pool.
/J
Enable 32-bit applications is set to true
still doen't work
And you already have testet u'r connection string directly in ssms ?
/J
ssms is not installed on my site's server ( The database server is another machine).
I tested it via a small c# console application and it was OK.
And how does ur connection string look like ? - remember to remove your pwd.
key="umbracoDSN" value="server=WIN-SQL;database=Megalim;user id=megalimnew;password=pwd"
Try change the named pipe "win-sql" to the correct ip-adress. Or maybe add : Trusted_Connection=False; to the connectionsstring, or use "Data Source=WIN-SQL;Initial Catalog=Megalim;User Id=megalimnew;Password=pwd;
The console app u testet with, did u run the test on the sqlserver, or on the webserver ?
And the sql server dont have an instance name ? ex WIN-SQL\Sqlexpress ?
I ran the test on the web server(with every suggested connection string)
"Data Source=Win-SQL;Initial Catalog=Megalim;Trusted_Connection=False;User Id=megalimnew;Password=pwd" connects successfuly, but I still get the error...
Hi Ben
Did you manage to get this solved?
If not then try to install ajax.net 1.0 - I can't remember why this is needed but I've learned that it is sometimes missing and hence causing trouble.
Hope this helps.
/Jan
is working on a reply...