Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2008 > SQL Server 2008
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2008 General discussion of SQL Server *2008* version only - not related to a specific book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2008 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old April 29th, 2010, 06:50 AM
Authorized User
 
Join Date: Oct 2007
Location: doncaster, , United Kingdom.
Posts: 46
Thanks: 1
Thanked 0 Times in 0 Posts
Send a message via MSN to debbiecoates
Question SQL 2008, Connection String

Hello

i had a little connection funtion that I could run from either vb or Access that would allow me to connect to our SQL Server 2000 with a trusted connection.
when we upsized to SQL Server 2005 Express I managed to adapt this, but I am having real problems with SQL Servr 2008.

The database is stored locally on the server, but I think our systems guy has set it up with sql Security instead of both, so now I have to add the sa password to my connection string. This isn't a problem as I have the sa password, but when I am running my function, it still seems to be using my normal network login and not the sa password i put in.

This is the code I am using

Dim cnn As ADODB.connection
Set cnn = New ADODB.connection
cnn.Open "Driver={SQL Server};Server=SQL-MAYTAS;Database=CRT1174;User ID=sa;Password=xxxx;Trusted_Connection=False;"

I would appreciate any help, I am really stuck on this
Thank You
Reply With Quote
  #2 (permalink)  
Old April 29th, 2010, 07:10 AM
Friend of Wrox
Points: 2,473, Level: 20
Points: 2,473, Level: 20 Points: 2,473, Level: 20 Points: 2,473, Level: 20
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: India
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

Please check the following link for usage of connections strings for SQL 2008
http://www.connectionstrings.com/sql-server-2008
__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.
Reply With Quote
  #3 (permalink)  
Old April 29th, 2010, 07:19 AM
Authorized User
 
Join Date: Oct 2007
Location: doncaster, , United Kingdom.
Posts: 46
Thanks: 1
Thanked 0 Times in 0 Posts
Send a message via MSN to debbiecoates
Default

I have, and as far as I can see my connection string is the same as in the heading Standard Security alternative syntax :

Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connecti on=False;

However, even thought I am putting a username of sa and the password of xxxx, its till looking for my domain name. rather than logging on a sa
Reply With Quote
  #4 (permalink)  
Old April 29th, 2010, 07:53 AM
Authorized User
 
Join Date: Oct 2007
Location: doncaster, , United Kingdom.
Posts: 46
Thanks: 1
Thanked 0 Times in 0 Posts
Send a message via MSN to debbiecoates
Default RESOLVED

I've sorted it, it was becasue i had use trusted connection on the end.
Reply With Quote
  #5 (permalink)  
Old November 21st, 2013, 01:02 PM
Authorized User
Points: 359, Level: 6
Points: 359, Level: 6 Points: 359, Level: 6 Points: 359, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2006
Location: Belgrade, Serbia, Yugoslavia.
Posts: 73
Thanks: 11
Thanked 1 Time in 1 Post
Smile Connected SQL Server 2008 with jdbc

Problam Connected SQL Server 2008 with jdbc
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection String with sql db martin330 Classic ASP Databases 0 April 26th, 2010 09:40 AM
SQL connection string naeem.net SQL Server ASP 0 July 10th, 2007 02:17 PM
SQL Server Connection String Nicky2k Classic ASP Basics 4 January 13th, 2005 04:22 AM
connection string for sql server rj1406 ASP.NET 1.0 and 1.1 Basics 6 September 16th, 2004 02:49 PM



All times are GMT -4. The time now is 01:13 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.