Profile Picture

Data Source connection failed login

Posted By Bill Rishsew 11 Years Ago
Author
Message
Bill Rishsew
Posted 11 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 2, Visits: 1

Look as I might, I can not find a thread related to failed SQL Logins.

My gut tells me it is on our end, but I'm not totally conviced.

I've been Admining SharePoint for a long time and am not sure why a service account can be used to do the add-on install, but not be used to query data from the the created DB.

This is a development instance, so I only use one service account throughout.

Any assistance would be greatly appreciated. I don't mind finding out I missed something in the install. After being in IT for 30 years, I have no pride.



Attachments
1.jpg (441 views, 105.00 KB)
Nevron Support
Posted 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

Hello Bill,

You can take a look at the Help Documentation: http://helpsharepointvision.nevron.com/

Connection to Data >> Connecting to a Database

 

Visit http://www.connectionstrings.com for a complete specification of the connection string format for each particular database connection.

 

In your case, the connection string looks incorrect. You have not specified the SQL server (Data Source= empty).

 

Try using the SQL server name and check your connection string.

Best Regards,
Nevron Support Team



Bill Rishsew
Posted 11 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 2, Visits: 1

Our DBA and I combed through the help files and made use of the connection strings in the Nevron Help and at the sight you referenced for connection strings.

It wasn't until we set up a SQL Account (not a Windows Domain account) and used this account to connect. By passing Windows Authentication.

Our connection string: Data Source=xxxx\xxxx;Initial Catalog=NevronSPVisionExamplesDB;Integrated Security=False;User ID=xxxx;Password=xxxx

The connection string is exactly what were using before when we were attempting to use Windows Authentication with a Doman Service Account.

Seems odd to us that Windows Authentication is an option, but doesn't work.

Should we be able to use a Windows Domain Service Account?





Similar Topics


Reading This Topic