VersaCat - Support, Bugz & Troubleshooting

Welcome Guest

Search | Active Topics | Members | Log In | Register

VersaDev Community Forum » versaSRS » Support, Bugz & Troubleshooting » VersaCat

VersaCat

Options

Previous Topic · Next Topic

availit

Posted: Tuesday, August 25, 2009 9:31:45 PM

Rank: Newbie
Groups: Member

Joined: 8/10/2009
Posts: 5
Points: 15

Hi

Have installed versacat for client access, configured firewall for port forwarding, can access the login screen when using https://*externalipaddress*/versacat. I've set up a test primary contact, and entered the username & password in the VersaCat tab. Trying to login using these credentials returns :-

Invalid credentials, please re-enter. Error Accessing Database.
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)
.Net SqlClient Data Provider

Versacat defaults to forms based authentication, haven't changed this. Also have the database set up to allow remote connections.

Am I missing something?

Cheers

availit

Posted: Wednesday, August 26, 2009 1:36:43 AM

Rank: Newbie
Groups: Member

Joined: 8/10/2009
Posts: 5
Points: 15

To add a bit more - using sql express, so figured might be something in the web config file for VersaCAT, with localhost specified in the <connectionStrings>

so - replaced the server=localhost with server=%nameofserver\sqlexpressinstancename%

<connectionStrings>
<add name="DSN" providerName="System.Data.SqlClient" connectionString="server=%servername%\sqlexpressinstance;database=VersaSRS;uid=versasrs;pwd=Versa2008!"/>
<add name="ClientValidationDSN" providerName="System.Data.SqlClient" connectionString="server=%servername%\sqlexpressinstance;database=VersaSRS;uid=versasrs;pwd=Versa2008!"/>
<add name="KBDSN" providerName="System.Data.SqlClient" connectionString="server==%servername%\sqlexpressinstance;database=VersaSRS;uid=versasrs;pwd=Versa2008!"/>
<add name="CustomFilterDSN" providerName="System.Data.SqlClient" connectionString=""/>
</connectionStrings>

Now getting

Invalid credentials, please re-enter. Error Accessing Database.
Login failed for user 'versasrs'.
.Net SqlClient Data Provider

should I be changing the versasrs credentials?

availit

Posted: Wednesday, August 26, 2009 3:16:30 AM

Rank: Newbie
Groups: Member

Joined: 8/10/2009
Posts: 5
Points: 15

ahem..... from the readme file ...... Tip: The DSN connectionString will be the same as that defined by SqlServerConnectionString within the web.config of versaSRS.

that will be working now then

<embarrassed smile>

as you were

Users browsing this topic

Guest

VersaDev Community Forum » versaSRS » Support, Bugz & Troubleshooting » VersaCat

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.