Hi Katerina

Could you describe in a bit more details what it is you're trying to do that gives you this error please?

/Jan

Hello Jan,

I would import the application via IIS7 (which is also compatable with IIS6), I change the App pool permissions to Network Services and then I add in the connection strings the credentials for the DB that is combined with the site but it doesnt seem to connect. here is the string "Server=SERVERNAME\SQLEXPRESS;Database=db-001;User ID=db-01". Is ther another want to have the IIS and the DB to connect ? Would I need to install the umbraco 4.0*.

Thank you

Katerina

Hi katerina,

Are you able to connect to the database in SQL management studio using those creditials?  Does the user have the permissions to access the database?

The problem is the creditials you have are not valid for the SQL instance or the user does not have permissions on the database.

Charlie

Hello Charlie,

Ive added the  .\administrator as a owner in the db permissions, do I need to go to into a table and change the the credentials ?

-this IIs site is from a different server and db. do I need to change any settings from the db with a new server name and ip address?

Katerina

Hi Katerina

Could you please provide much more detail about your setup? :) As Charlie is pointing out above it seems like your database credentials are wrong. But I'm not sure wether the database has been created on your server or not?

Are you trying to get up and running on a local environment? Or are you trying to deploy to a live environment?

Make sure that you read the documentation on how to install Umbraco - If you dig through it you can find information about system requirements and how to setup permissions as well.

Hope this helps.

/Jan

Im not sure on what to do, This is what I have an IIS site from a different server and DB this new server is a win 2k8 R2, IIS 7 capatable with II6 and SQL express 2014

I have only imported the site via IIS import application function. the old server was using umbraco ver 4, do I need to install umbraco ver 4 for the db to work with the IIS site ?

-Katerina

Ok what i would do i go into SQL management studio and try to connect from there first off.

If you have the ip address that will be the serverName.  Do you know if you have a user that has SQL Server Authentication on the database?

In SQL Management studio:

Server=SERVERNAME\SQLEXPRESS;

Authentication: SQLSERVERAUTHENTICATION

USERNAME:db-01

PASSWORd:  Password for the database

Once you can log into the database doing that try those settings in the web config.

If that does still does not work it will be because the user does not have sufficent permissions for the database which you will need to apply :)

Charlie :)

Im still getting the error

The network path was not found

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ComponentModel.Win32Exception: The network path was not found

Source Error:
Stack Trace:

[Win32Exception (0x80004005): The network path was not found]

Hi katerina 

Have you got sql management studio?  Have you tried logging in with those credenitials?

Could you try the crentials in management studio like this and let me know if you can login?

Charlie

I can log in

<add name=umbracoDbDSN" connectionString="server=.\SQLEXPRESS;database=db-SOW12; UserID=administrator;password=********"providerName="System.Data.SqlClient" />

Ok so can you try this connection string and see if you get any further :).

Charlie

Hi for some reason i cannot see your comments but i made a typo sorry should be

<add name="umbracoDbDSN" connectionString="server=.\SQLEXPRESS;database=db-SOW12; UserID=administrator;password=********"providerName="System.Data.SqlClient" />

<add name="umbracoDbDSN" connectionString="server=.\SQLEXPRESS;database=db-SOW12;user id=.\administrator;password=!q2w3e4R" providerName="System.Data.SqlClient"/>

Sorry my bad again :) Hope this works now

Server Error in '/' Application.

The network path was not found

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ComponentModel.Win32Exception: The network path was not found

Source Error:

Stack Trace:

[Win32Exception (0x80004005): The network path was not found]

[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +414
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +78
   System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +196
   System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +146
   System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +16
   System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +94
   System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +110
   System.Data.SqlClient.SqlConnection.Open() +96
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +60
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) +135
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +146

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +228
   umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0() +140
   umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +207
   umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +120
   umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemRemovedCallback refreshAction, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +117
   umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +114
   umbraco.cms.businesslogic.web.Domain.GetDomains() +225
   umbraco.cms.businesslogic.web.Domain.GetDomain(String DomainName) +95
   umbraco.cms.businesslogic.web.Domain.Exists(String DomainName) +44
   umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain) +484
   umbraco.requestHandler..ctor(XmlDocument umbracoContent, String url) +777
   umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e) +1497
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Page.OnPreInit(EventArgs e) +9531286
   System.Web.UI.Page.PerformPreInit() +31
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +335

Ok, where is your website and where is your database?

Are they on the same machine?

<< An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below >>

Is this becasue I dont have the original pwd and username, I took a db.bak and imported onto the sql express 2008 r2 and then added permission to the .\administrator (dbo).

Yes they are on the same server.

is working on a reply...