June 2, 2013 at 6:21 am
I have SQL Server 2008 R2.
I need the location and name of SQL Server 2008 R2 to put into my connection string.
June 2, 2013 at 8:54 am
philosophaie (6/2/2013)
I have SQL Server 2008 R2.I need the location and name of SQL Server 2008 R2 to put into my connection string.
Well we can't really help too much. You can get the name of the server with:
select @@SERVERNAME
I don't understand what you mean by the location of the server for a connection string. Have you looked at http://www.connectionstrings.com/[/url]?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 2, 2013 at 10:54 am
How do you get a USER ID and PASSWORD in your connection string.
June 2, 2013 at 11:19 am
What type of front-end are you using to connect to SQL Server?
Andrew SQLDBA
June 2, 2013 at 8:05 pm
I am using Microsoft SQL Server 2008 R2.
June 2, 2013 at 8:46 pm
philosophaie (6/2/2013)
I am using Microsoft SQL Server 2008 R2.
That is the backend, not the front end. Please take a look at connection strings.com. It provides examples for nearly every connection string you would need for any type of data source. It will provide answers for all the questions you asked.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply