Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohan_iiitc
Starting Member
11 Posts |
 Posted - 2010-05-07 : 05:19:55
|
| Friends I need to know the following thing :To create a linkedserver the querry is :sp_addlinkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] [ , [ @provider= ] 'provider_name' ] [ , [ @datasrc= ] 'data_source' ] [ , [ @location= ] 'location' ] [ , [ @provstr= ] 'provider_string' ] [ , [ @catalog= ] 'catalog' ] How to check out what is - 'provider_nam- 'data_source' |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-05-07 : 05:27:10
|
| I think the below method should work.1.Save a file on desktop with .udl extension.2.Double click on the newly saved file.3.Select the provider, enter server name and other credentials.4.Close the "Data Link" application (the application opened in step 2).5. Open the file with notepad. You can find the provider details.In case this method is not working for you then let us know.Regards,BohraI am here to learn from Masters and help new bees in learning. |
 |
|
|
rohan_iiitc
Starting Member
11 Posts |
Posted - 2010-05-07 : 05:39:36
|
| thanks , I was able to get it. And I also created linkedbut when i fired some query i got the below querryOLE DB provider "SQLNCLI10" for linked server "DELL1" returned message "Login timeout expired".OLE DB provider "SQLNCLI10" for linked server "DELL1" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".Msg 53, Level 16, State 1, Line 0Named Pipes Provider: Could not open a connection to SQL Server [53]. PLease help. |
|
|
|
Asken
Starting Member
38 Posts |
Posted - 2010-05-11 : 08:01:09
|
http://msdn.microsoft.com/en-us/library/ms190479.aspx
Reporting & Analysis SpecialistHelping others helps me get better... |
|
|
|
Asken
Starting Member
38 Posts |
Posted - 2010-05-11 : 08:03:38
|
Try the SQLOLEDB provider instead...
Reporting & Analysis SpecialistHelping others helps me get better... |
|
|
|
|
|
|
|
|
how check your data source in SQL 2008?