Data Source connection failed login


Author
Message
Bill Rishsew
Bill Rishsew
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
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?


Nevron Support
Nevron Support
Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)
Group: Administrators
Posts: 3.1K, Visits: 4.2K

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
Bill Rishsew
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
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 (496 views, 105.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search