How to connect to SQL Server 2K without the machine name ?

With SQL Server 7, I could connect to a "local" server

driver={SQL Server};server={Local};uid=sa;pwd=password;

with SQL Server 2K it seems to need the computer name

driver={SQL Server};server=MachineName\InstanceName;uid=sa;pwd =password;

How can I replace "MachineName\InstanceName" by "{Local}"Originally posted by Karolyn
With SQL Server 7, I could connect to a "local" server

driver={SQL Server};server={Local};uid=sa;pwd=password;

with SQL Server 2K it seems to need the computer name

driver={SQL Server};server=MachineName\InstanceName;uid=sa;pwd =password;

How can I replace "MachineName\InstanceName" by "{Local}"

Is the machine you connecting to your local machine?|||yeap !|||if its the default instance of sql server 2000

Provider=SQLOLEDB.1;Persist Security Info=False;Connect Timeout=0;User ID=user;Initial Catalog=dbname;Data Source=local;PASSWORD=password;

else

Provider=SQLOLEDB.1;Persist Security Info=False;Connect Timeout=0;User ID=user;Initial Catalog=dbname;Data Source=local\instancename;PASSWORD=password;|||Originally posted by Karolyn
yeap !

did you try editing your sql server properties?? are you using the right password? cause when you connect to your local machine you normally use use windows and not sql and windows to connect ...try connecting with windows authentication...hope this helps..it should work ..that is what i did...providing other users dont connect to your local machine|||Data Source=local\mercure

The connection does'nt find the server|||Originally posted by Karolyn
Data Source=local\mercure

The connection does'nt find the server

Edit your sql server properties|||where do I get them edited ?|||1
ProductName NULL Microsoft SQL Server 2
ProductVersion 524288 8.00.760 3
Language 1036 Franais (France) 4
Platform NULL NT INTEL X86 5
Comments NULL NT INTEL X86 6
CompanyName NULL Microsoft Corporation 7
FileDescription NULL SQL Server Windows NT 8
FileVersion NULL 2000.080.0760.00 9
InternalName NULL SQLSERVR 10
LegalCopyright NULL 1988-2003 Microsoft Corp. All rights reserved. 11
LegalTrademarks NULL Microsoft is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation 12
OriginalFilename NULL SQLSERVR.EXE 13
PrivateBuild NULL NULL 14
SpecialBuild 49807360 NULL 15
WindowsVersion 170393861 5.1 (2600) 16
ProcessorCount 1 1 17
ProcessorActiveMask 1 00000001 18
ProcessorType 586 PROCESSOR_INTEL_PENTIUM 19
PhysicalMemory 503 503 (527941632) 20
Product ID NULL NULL|||Originally posted by Karolyn
where do I get them edited ?

right click on (local)windows nt then go to edit sql server properties and change it theresql

How to connect to remote MSDE database using VB.NET

Greetings
I have a VB.NET application that works great with a local MSDE database. But, when I try to revise my connection string to point to a remote MSDE server and database, it fails. The MSDE Server Manager can pick up the remote server and tell me its runni
ng, but when I try to register it using SQL Server, or use a DSN to connect to it, I get a "SQL Server does not exist or access denied. ConnectionOpen(Connect())" My connection string is:
Provider=SQLOLEDB.1;Server=DSS\VSDOTNET;Database=d atabase;User ID=sa;Password = xxxxx;Integrated Security=SSPI
Any help will be appreciated. Thanks...
- Tim B.
hi Tim
"Tim Balderramos" <pacmantab@.hotmail.com> ha scritto nel messaggio
news:28F08CF8-86CF-4C04-9E5A-900296EC78A7@.microsoft.com...
> Greetings
> I have a VB.NET application that works great with a local MSDE database.
But, when I try
>to revise my connection string to point to a remote MSDE server and
database, it fails. The
>MSDE Server Manager can pick up the remote server and tell me its running,
but when I try
>to register it using SQL Server, or use a DSN to connect to it, I get a
"SQL Server does not
>exist or access denied. ConnectionOpen(Connect())" My connection string
is:
> Provider=SQLOLEDB.1;Server=DSS\VSDOTNET;Database=d atabase;User
>ID=sa;Password = xxxxx;Integrated Security=SSPI
the most frequent causes of that kind of error are reported in
http://support.microsoft.com/default...06&Product=sql
KB article...
please verify the remote MSDE instance has enabled networkprotocols too,
using the remote Server Network Utilityes (svrnecn.exe)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I think that does it. Here is what my co-worker did:
During MSDE setup, use SECURITYMODE=SQL
Then use SVRNETCN.exe and enable TCP/IP as a network library. I did this on
both machines, but you may not need to do it for both (wasn't sure, but didn't
think it mattered).
Here's the connection string that was working -
Provider=SQLOLEDB;Data Source=wrctest;user id=sa;password=wrctest;Initial
Catalog=winthrop;Net=dbmssocn;Auto Translate=True;Persist Security
Info=False;Use Encryption for Data=False

how to connect to my local SQL server (For Developing)

I can't found my way to connect to local SQL server (On My Computer)

can any body help me

Ahmed Gaber

Perhaps these will help:

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

sql

How to Connect to a SQL Server thru a firewall

Hi, Guru,
I have a SQL Server running behind a firewall. I also have a client
installed on my local machine. How should I configure the client to
connect to the server? What port do I need to ask the network/security
admin to open on the firewall? All installation on the server and on the
client are default. I am not familiar with SQL Server, but I have some
common sense. What should I put in the "Server Alias"? The IP of the SQL
Server? What if I run a named instance on the server. Any special
configuration I need to do on Client Network Utility?
If you could show me step by step, it would be great. If you can point me
to some online reference, it will be also great.
Any of you help is appreciated.
ChopinThe default sql server tcp port is 1433. So if you have to connect to a
server behind a firewall, you have to ask the network team to open this
port. To make sure it's working you can run the following command from the
client machine:
telnet servername_or_ip 1433
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Chopin Hu" <huchopin@.yahoo.com> wrote in message
news:ux7cmyGAEHA.3452@.TK2MSFTNGP11.phx.gbl...
> Hi, Guru,
> I have a SQL Server running behind a firewall. I also have a client
> installed on my local machine. How should I configure the client to
> connect to the server? What port do I need to ask the network/security
> admin to open on the firewall? All installation on the server and on the
> client are default. I am not familiar with SQL Server, but I have some
> common sense. What should I put in the "Server Alias"? The IP of the
SQL
> Server? What if I run a named instance on the server. Any special
> configuration I need to do on Client Network Utility?
> If you could show me step by step, it would be great. If you can point
me
> to some online reference, it will be also great.
> Any of you help is appreciated.
> Chopin
>|||try this
http://support.microsoft.com/defaul...kb;en-us;287932
Br,
Mark.
"Chopin Hu" <huchopin@.yahoo.com> wrote in message
news:ux7cmyGAEHA.3452@.TK2MSFTNGP11.phx.gbl...
> Hi, Guru,
> I have a SQL Server running behind a firewall. I also have a client
> installed on my local machine. How should I configure the client to
> connect to the server? What port do I need to ask the network/security
> admin to open on the firewall? All installation on the server and on the
> client are default. I am not familiar with SQL Server, but I have some
> common sense. What should I put in the "Server Alias"? The IP of the
SQL
> Server? What if I run a named instance on the server. Any special
> configuration I need to do on Client Network Utility?
> If you could show me step by step, it would be great. If you can point
me
> to some online reference, it will be also great.
> Any of you help is appreciated.
> Chopin
>sql

How to Connect to a SQL Server thru a firewall

Hi, Guru,
I have a SQL Server running behind a firewall. I also have a client
installed on my local machine. How should I configure the client to
connect to the server? What port do I need to ask the network/security
admin to open on the firewall? All installation on the server and on the
client are default. I am not familiar with SQL Server, but I have some
common sense. What should I put in the "Server Alias"? The IP of the SQL
Server? What if I run a named instance on the server. Any special
configuration I need to do on Client Network Utility?
If you could show me step by step, it would be great. If you can point me
to some online reference, it will be also great.
Any of you help is appreciated.
ChopinThe default sql server tcp port is 1433. So if you have to connect to a
server behind a firewall, you have to ask the network team to open this
port. To make sure it's working you can run the following command from the
client machine:
telnet servername_or_ip 1433
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Chopin Hu" <huchopin@.yahoo.com> wrote in message
news:ux7cmyGAEHA.3452@.TK2MSFTNGP11.phx.gbl...
> Hi, Guru,
> I have a SQL Server running behind a firewall. I also have a client
> installed on my local machine. How should I configure the client to
> connect to the server? What port do I need to ask the network/security
> admin to open on the firewall? All installation on the server and on the
> client are default. I am not familiar with SQL Server, but I have some
> common sense. What should I put in the "Server Alias"? The IP of the
SQL
> Server? What if I run a named instance on the server. Any special
> configuration I need to do on Client Network Utility?
> If you could show me step by step, it would be great. If you can point
me
> to some online reference, it will be also great.
> Any of you help is appreciated.
> Chopin
>|||try this
http://support.microsoft.com/default.aspx?scid=kb;en-us;287932
Br,
Mark.
"Chopin Hu" <huchopin@.yahoo.com> wrote in message
news:ux7cmyGAEHA.3452@.TK2MSFTNGP11.phx.gbl...
> Hi, Guru,
> I have a SQL Server running behind a firewall. I also have a client
> installed on my local machine. How should I configure the client to
> connect to the server? What port do I need to ask the network/security
> admin to open on the firewall? All installation on the server and on the
> client are default. I am not familiar with SQL Server, but I have some
> common sense. What should I put in the "Server Alias"? The IP of the
SQL
> Server? What if I run a named instance on the server. Any special
> configuration I need to do on Client Network Utility?
> If you could show me step by step, it would be great. If you can point
me
> to some online reference, it will be also great.
> Any of you help is appreciated.
> Chopin
>

how to connect to a local sql server on your laptop?

i have problems connecting to the local server on my laptop. i ahve used the following code but it gives me an error saying login flaied for user "sa" or "sekhar".

i tried using the username and password i use to log onto my computer. but it doesnt work.
can anyone tell me how to do it?

the code is typed is

connection = new sqlconnection("server=localhost;uid=sekhar;pwd=sekhar;database=chandu")
..................
.............................
........................
connection.open()..............i have all the next statements correct.
my username is sekhar and the password is sekhar too but it gives me an error.
somebody help me

Thank you

sekhartry using server=(local)

and whether you need the password or not depends on how the SQL Server is set up. does the users view show a user called 'sekhar'? no? when you right click the server node and go to properties->security, does it show windows auth only, or Windows and SQL Server auth?

How to Connect remote Access database to SQL server

Hai,
I want to Convert remote Ms access data to sqlserver data.
Here i am using FTP Task in DTS for downloading Ms Access database to local machine.
After that, I convert it to sql data.
But, most of time, With download the mdb file, the message 'Opreation sucessfully' display.
Please give solution for this.
With regards,
dharmaprakash.
**********************************************************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...Please do not post separately in different groups.
Whats the matter if its performed successfully.
Jens Süßmeyer.

How to connect instance on local server

hi!
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegroups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>

How to connect instance on local server

hi!
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!
You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegro ups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>

How to connect instance on local server

hi!
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegroups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>sql

How to configure SQL SERVER in local on windows xp os

Hi,

I need an suggestion how to run sql server in local. In my system sql server was not running in local, but when I connect to our remote data base with it's IP ,username and password, I can able to connect, but not in the local system sql server.I am using windows XP OS. I tried to register a new connectio to my local but i am getting an error the Acdess denied or connection faild.

Plz any one suggest me how to troubleshoot this problem

Regards
SarathyCould you tell some more details, Version of SQL Server, Firewall configured etc.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

How to configure Report Server in SQL Server 2005?

Hello, everyone:

I hope my question is clear.

I have SQl Server 2005 installed in local computer. I am planning to create report by Report Service so a report server is needed by which I can deploy report from my local computer to that server. How to intall the report server in another computer/

Thanks

ZYTZYT,
Your question is clear, but it doesn't look like you've done any research on the subject. There are plenty of KB articles and technical support documents regarding Reporting Services on the Microsoft website and numerous books exist on the subject.
If you encounter a specific problem when trying to implement Reporting Services having done the necessary research, people are more likely to help you, but they won't generally do all your work for you!

Lempster :S

how to configure from local distributor to remote

Hi,
I already have a merge replication setup successfully.
However I now need to change the network from a central publisher to a
central publisher with remote distributor
See http://www.databasejournal.com/features/mssql/article.php/1458491 and
Ctrl+F for the words central publisher.
I tried to redo another publication but the wizard no longer asks me whether
I want my distributor to be on a remote machine.
Then I tried to follow this article
http://technet.microsoft.com/en-us/library/ms151192.aspx
and looked for a Configure distribution which I cannot find.
Then I tried this article
http://msdn2.microsoft.com/en-us/library/ms147363.aspx
, but realise that the value of installed in the result set is 1, so I am
not sure what I should do next. Furthermore I am unfamiliar with the T-SQL
syntax necessary to make the changes.
FYI, the result set from using the sp_get_distribution was
installed = 1
distribution server = machineName
distribution db installed = 1
is distribution publisher = 1
has remote distribution = 0
Please advise. I am running SQL server 2005 Trial edition on 2 separate
win2003 server with one of them already set up as a successful central
publisher.
If I really have no choice but to use T-SQL please give me more explicit
details. Thank you.
This is pretty much a one-off choice. To move to a remote distributor I'd
script out the publications, remove the subscriptionas and publications,
remove the distributor entirely, readd the distributor remotely then add the
publications again.
HTH,
Paul Ibison

How to configure connection string for remote server?

Sorry for the newbie question, but...

I have developed a website on my local development machine. When I create the connections string VS automatically creates a path to my local hard drive inside the string.

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\Mike\My Documents\Visual Studio 2005\WebSites\PostAlertz\App_Data\PADatabase.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True

However, when I deploy this website to a remote server, SQLExpress tries to attach to the file using the wrong path. How do I fix this?

Your patience is appreciated...

Hi

Here is a sample connection string,and you can find more onhttp://www.connectionstrings.com/:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

HOW-TO: Database from VWD to Shared Host tells you how to copy database to share host.

Hope this helps.

|||If you have SQL Express instance installed on the remote server, just set the correct path for the mdf file like:

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|PADatabase.mdf;User Instance=true

How to compare structure of two db objects?

Hi,

I would like to compare an object inside a local and remote db and I would like see if any changes has been made to the object structure (table) since the last update.

ThanksRed Gate (www.red-gate.com) has a tool SQL COmpare that does exactly that.

To do it on the cheap, you might want to script the object in each copy of the database and then do a text compare of the two.|||I guess we were on the same page, thanks.