Developer forum

Forum » Development » SQL Error

SQL Error

E-mail notifications
Kasper Holm
Reply
Posted on 07/09/2011 12:40:03 
 
Hello every one..
i have been working on setting up a development version of an existing and running version of dynamicweb
i downloaded the files from the server and took a backup og the database, after this i recreatet the backup on my development sql server and det up the solution on the IIS, after this i changede the conntetion info in the GlobalSettings.aspx 

<Password>Password</Password>
<Type>ms_sqlserver</Type>
<UserName>User</UserName>
<Database>alumeco</Database>
<SQLServer>192.168.1.4</SQLServer>

and now i get this error

Please wait!
The SQL-Server database could not be opened ('Ecom.mdb') - the error is:
 System.Data.SqlClient.SqlException: Login failed for user ''.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Dynamicweb.Database.GetConn(String strDatabase)

since it's the same files, only thing i changed was the connection info, to me it looks like it dosent read from the setings file, hope you can help


Replies

 
Nicolai Høeg Pedersen
Posted on 07/09/2011 12:56:34
Reply
If you are missing the /Files as a virtual (or physical) directory of your website in IIS, you would see an error like this - because, yes - it seems like DW cannot find the /Files/Globalsettings.aspx file.
 
Kasper Holm
Posted on 07/09/2011 13:00:44
Reply

If you are missing the /Files as a virtual (or physical) directory of your website in IIS, you would see an error like this - because, yes - it seems like DW cannot find the /Files/Globalsettings.aspx file.

Yes, but its not missing, any sugestions to how i can debug this problem or what i should do from here ?
 
Nicolai Høeg Pedersen
Posted on 07/09/2011 13:03:59
Reply
When you right click your /Files in IIS manager, and choose browse, do a folder then opens that contains the Globalsettings.aspx file?
 
Kasper Holm
Posted on 07/09/2011 13:05:39
Reply

When you right click your /Files in IIS manager, and choose browse, do a folder then opens that contains the Globalsettings.aspx file?

Yes it does, and if i open the file, i can see that the data in it is the one i have editet
 
Nicolai Høeg Pedersen
Posted on 07/09/2011 13:33:35
Reply
Permissions? Does the IIS instance have rights to read from that folder?
 
Kasper Holm
Posted on 07/09/2011 13:49:35
Reply
This post has been marked as an answer

Yes it has permesions, i fixed it by updating the solution and then it work.
Votes for this answer: 0

 

You must be logged in to post in the forum