What Should I Do To Connect SQL Server To My Computer (was New To SQL)

Mar 14, 2006

I'm new to programing things, i'm on my own with MCAD/MCSD Amid Calani, i came to the point were i can"t go any further: i have VS enteprise architect,but i have only instece of SQL server,recently i downloaded SQLExpress , what should i do to connect SQL server to my computer, just because i'm new to to it looks stupid but maybe someone can HELP me with this. HELP, HEL,SOS,SOS...:eek:

View 14 Replies


ADVERTISEMENT

Unable To Connect Second Computer To SQL Server Database

Aug 11, 2006

Hello all,

New forum member here, and pretty new to SQL Server. My question is I'm having an impossible time trying to connect MS Access on Computer A to a database running on SQL Server 2k (SP3) on Computer B. Every time I try to create a new ODBC connection on Computer A, I get the dreaded Server Error 17 (SQL Server does not exist or access denied). I have no problems making the ODBC connection on the computer running SQL Server (Computer B).

My connection settings are as follows:

Computer A name = MAINDESKTOP
Computer B name (contains SQL Server) = HOMELAPTOP
Workgroup name = WORKGROUP

Server Properties:

Name = HOMELAPTOP
Authentication = SQL Server and Windows
Registered SQL Server Properties = Use SQL Server authentication, and I'm using a login name and password
Server Network Utility = TCP/IP network protocol enabled, with default port 1433
Server Client Network Utility = TCP/IP network, default port 1433

Under "Security", I have created a new login using SQL Server Authentication called "bradley", and have assigned a password to the new login. I've noticed that when I open the login properties dialogue, there are always more ***'s in the password field than the number of characters I originally used, but I suspect that's normal. I have assigned a database called "Costume" to "bradley", and have verified that the permission is checked on the Database Access tab for user "bradley".

Under "DatabasesCostume", I have verified that there is a user called "bradley" with the same login name and user name.

No matter what I try, I can't get Computer A to connect to Computer B's SQL Server database. I have no problems with any other types of connections (pinging, internet, file transfers).

This can't be that difficult! Any ideas?

Thank you!
Brad

View 6 Replies View Related

Connect SQL Server Express 2005 On A Remote Computer

May 28, 2006

Hello Everyone,

I just got a Virtual Dedicated Server and installed SQL Server Express 2005 on it and while I was installing choose Mix Mode authentication and setup a sa password.....

I want to connect to that database remotely from my machine using VS 2005 or Management Studio....both are encountering the same problems.....

On the Virtual Dedicated machine if I install management studio I run has no problem....it asks me for the server name : somethingSQLEXPRESS then username and password and works fine...

The same thing I try to do remotely is not happy with ....I tried to give the IP address of the server same thing no luck.....

Can somebody tell me what I'm doing wrong and where....

Thanks,

Harsimrat

View 1 Replies View Related

Cannot Connect To SQL Server 2005 April CTP From Remote Computer

Jun 17, 2005

Hi,

View 18 Replies View Related

How To Connect To SQL Server 2000 And SQL Server 2005 In One Computer????

Dec 8, 2007

Hi All!!!
In my Computer has MS SQL Server 2000(with default Instance) and now I Install MS SQL server 2005(with Instance name: SQL2005 ). Now I want to write Web Application to connect to the both databases (SQL Server 2000 and MS SQL Server 2005), How to Add connection string in my web.config to do it.
Help me ???
Thanks & Regards,

View 3 Replies View Related

IIS6 Won't Connect To Local Computer

May 11, 2007

I open II services.

From this point I right click on information services and clicked "connect to computer" and located mine. When I hit "ok", I got "This computer is not running Internet Information Services Ver 4 or higher".
IIS6 is starting, it just won't connect to local computer.

Previously someone said to post the event logs. I can't find them. Where are they??

Thanks

All help is appreciated.
Thanks

View 2 Replies View Related

Connect To Sqlexpress From Network Computer

Mar 3, 2007



Hi

Please if any one can answer.I am developing .net vb app sqlexpress database.

In single user work ok.In multiuser from other computer on network I cannot get data.Any form without data workok fine . The error I am getting is as follows.



Application attempted to perform operation not allowed by the security policy.

request for permission of type

'System.data.sqlclientpermission,system.data,

version=2.0.0.0.,culture=Normal, publickeytoken=b77a5c561934e089'

Zaabdullah











View 1 Replies View Related

MSSQL 2000 - Cant Connect To DB From Remote Computer

Jun 21, 2006

Please bare with me as I do not have much knowledge in this area with MSSQL.

I have installed MSSQL 2000 Developer and I have setup a database which I am able to connect to and work fine with from the actual server MSSQL is installed on.

The problem comes in when i try to connect to that same database from a different remote server. It will not connect to the DB from this remote server but I know all the connection information is correct so its something on the MSSQL DB server causing this and not on this remote server.

Someone I know has had this problem and has fixed it but they wont tell me how. All I know is they said something about manually opening the ports on the MSSQL server and he also said when you set it to dynamicly determine the port that MSSQL is listening on it errored out. however if you set it staticly to 1433 it worked fine.

Ive also installed SP4 in attempt to fix this but no luck with that either. And I can also get the same exact remote server to connect to completely different DB server without issues.


If anyone can please help walk me through this I would be greatly appreciate and I am also willing to pay some money if it will make my life easier.

View 6 Replies View Related

Help - Can't Connect To Database After Computer Crashed During Table Alteration

Mar 26, 2007

I was altering a few columns (setting to allow nulls) on a large table (30+ million records) and the machine naturally crashed. I rebooted, and now I can't connect to the DB - enterprise manager hangs, and query analyzer times out. is it likely the whole DB is screwed up, assuming the table alteration was incomplete?

thankfully, I do have a backup, but for future reference, is there a preferred way to make changes to large tables? last time I did this it took over an hour, and enterprise manager gives no progress indication to make me feel more comfortable that it's actually doing something...

View 3 Replies View Related

SQL 2012 :: Can Connect To Default Instance With Computer Name InstanceID?

May 21, 2015

I create default instance on SQL Server 2012 Standard.

When I set it up, I changed instance id from 'mssqlserver', which is a default value, to 'new_instance_id'.

For some reason I want to connect to the instance with computername new_instance_id

Can I do it?

View 1 Replies View Related

Unable To Start T-SQL Debugging. Could Not Connect To Computer 'servername'.

Nov 9, 2007



I thought I would post how I got remote t-sql debugging working in my environment. Hope it might help someone.
I have two domains, DomainA and DomainB. DomainB has a one way external trust to DomainA. Dev Vista machine running VS 2005 is in DomainA logged in as user DomainAauser. SQL 2005 running on test Windows Server 2003 DC machine in DomainB under user DomainBuser. When trying to 'step into stored procedure' in VS, whether my data connection used windows authentication or sql server authentication, I would get the 'Unable to start T-SQL degbuggin...'. I could debug t-sql when I logged into the domain controller (console or rdp) and running VS on the server. I changed the SQL Server service to run under the DomainAauser account and I can now remote t-sql debug using both window authentication and sql server authentication. Hope this may help anyone that might run into this.

Regards,
RMcc

View 1 Replies View Related

XP Home -LAN Remote Access - Unable To Connect From One Single Computer.

Jan 5, 2007

Hi,

I have Windows XP Home Workgroup LAN.

I am treating one of the XP Home system as 'Server' and installed SQL Express 2005 SP1. Enabled remote connections access.

I have total 4 XP Home systems, out of which one i am treating as Server, from the rest 3 computers, 2 are successfully connected to the Server and able to access SQL Express without any problems. But the 3rd system is unable to communicate with the Server. I disabled all firewalls in this 3rd system but still unable to connect to the server. I am able to ping the server, browse for shared folders on the server. Except SQL Express remote connection, everything else in the network is accessible from this 3rd computer.

Can anyone help me on how to troubleshoot this 3rd computer sql express connection problem to the server.

I don't have any error message to provide here. It just says, unable to connect to sql server, verify username/password etc.

Is there any limitation on SQL Express remote connections ?

View 1 Replies View Related

I Got Error When I Connect Remotly Or From Other Computer And Also Gettting This Error : Cannot Use Special Principal 'sa'

Nov 1, 2007

Hello,
The problem which i am facing in SQL Server 2005 is that, I have 2 database and the owner of both the databases is sa but when I go to database > security > users here I cannot find 'sa' as user. when I am going to add that user I get following error :
cannot use special principal 'sa'

also when I connect sa on other computer I will not connect

I have already checked following thing :
The Authontication mode of SQL is mixed mode
database owner is also sa
sa is also enable


Please can any one help me I am in big trouble


Thanks and Regards
Asif Fattah
ERP Consultant

View 4 Replies View Related

How To Know Whether A Computer Is A Sql Server According To The Name Of Computer?

May 9, 2004

Thanks a lot

View 6 Replies View Related

Renaming The SQL Server Computer Name

Oct 10, 2001

Do I have to re-install SQL2000 if I change the Win2000 Server name.

Thanks

View 2 Replies View Related

Connecting To Sql Server From Another Computer

Mar 25, 2007

when i connect to sql from the same machine i use

mserver="newserverSQLEXPRESS"

what would i use connecting from another machine

i tried the ipaddressSQLEXPRESS
and if didn't work

View 3 Replies View Related

I Can't Find Sql Server On My Computer

Feb 4, 2006

I installed sql server on my PC, and when I look at the Programs I dofind sql server, but when I click on that I get "configuration tools".I don't see anything that says "enterprise manager" for instance. Howcan I find it so I can make a shortcut to it?Thanks

View 4 Replies View Related

Moving My SQL Server To Another Computer

Jul 14, 2006

I will moving my SQL Server to another server. The plan is to stop SQL Server copy database file to a temp netwokr location, Switch off this server. Configure the new server with the same name and IP, install SQL to the same paths and service pack to the same level (SQL 2000 sp3). Then start and stop the SQL server. Once stop I will then copy the old database file over the new ones.

I know in general this works as I have doen this many times before expect this time round there is a replicaiton database which is new, I am expecting this will work the same but has any one else tried this before?

View 1 Replies View Related

Cannot Restore Database In The Computer Is Setuped SQL Server 2000 And SQL Server 2005

Dec 27, 2007

Hi All
I have Computer is setuped SQL Server 2000 and SQL server 2005 when I restore SQL Server 2005 it's OK but when it's not OK when I restore in SQL Server 2000. The Error as follows:

Please help me to solve this problem. Thanks

View 1 Replies View Related

How Can I Create New Instance In My Computer Or Any Server ?

Jun 26, 2007

If there is one instance in a server and I would like to create another instance, what should I do ?????
 
Or if my computer is not included any instance, How can I create new instance on my computer ? 
????
 
Please give me any suggestions ......

View 1 Replies View Related

How To Move A SQL Server Database From One Computer To Another.

Jan 8, 2004

Currently I'm working on my Desktop computer but I wanna put all my data to my laptop so that I could continue my work on my laptop.

How can I transfer my SQL Server database to my laptop?

View 3 Replies View Related

Gettting Time Of SQL Server Computer

Jul 20, 2005

Hi everyone,Is there a system stored procedure or another way that I can retrievethe current date and time of the SQL Server computer?Any info would be appreciated...Thanks in advance,Dan

View 1 Replies View Related

Server Name , Instance Name, Domain Name Computer Name

Mar 28, 2008

I am still trying to figure some last issues before installing sql 2005 standard edition.
vista issues, sql 2005 sql sp2 etc
My question is simple actually, It is about configuring administrative accounts on my computer.
I wish to use configure the administrative account?
I wish to use a third party in deploying sql reporting services
Do I need to set up a local account in report manager?
the article in setting up reporting services in vista
uses domain/instance name or computer name/instance name
how do I do correctly set this up? I will be using july 2007 dvd for
sp2 ( I believe) is their any article explaining the steps in sql sp2
some people seem to have trouble in the restore step.....Thanks
I just want to be prepared....can I install cd's without the use of the internet....

View 1 Replies View Related

Uninstalling Sql Server 2005 From My Computer?????

May 7, 2008

i am having some issues..hopefully someone can help me..i just finished my database class...we had to install sql server 2005...i am running windows xp home...when i went to install sql...there was one error that i was getting...it was about the iis function, which i know that it won't work with the home edition...i finished the install, without the iis, so i can try to work on some things for class...i also had to install northwinds and pubs...now that the class is over, i want to get rid of it all...i tried to follow somewhat of the uninstall process but now i am getting problems...i can't figure out how to uninstall the northwinds and pubs..it keeps saying that it is being used by another person or program and it won't let me uninstall....can someone what me through the uninstall process of both the northwinds, pubs, and all of sql server 2005...i don't know much about computers....thanks you so much for helping in advanced...
crystal

View 4 Replies View Related

How To Access Sql Server Express From Other Computer On The Netwrok

Jan 8, 2007

Hi expertsI use a sqlserver on a local computer. i want to access the sqlserver from other computers on the network using the VWD. When trying to connect to the database i get the error:"An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" I enabled the TCP/IP and the Named Pipes protocols on the server and still the same error. Thanks 

View 2 Replies View Related

SQL Server 2005 Developer Edition And Vwd On Same Computer

Feb 9, 2007

Will SQL Server 2005 developer edition and Visual Web Developer Express
work on the same machine?  One reviewer of SQL Server 2005 developer
edition on amazon.com stated won't work on the same machine?  Is this
true?

View 6 Replies View Related

Backup A Remote SQL Server To Local Computer?

May 4, 2005

Is there an easy way to backup a database on a remote SQL Server to a backup file on my local computer?

View 3 Replies View Related

How To Open And See The MSSQL SERVER Tables In My Computer ?

Nov 9, 2004

Hallo everyone
Now I have to analyse so many Software systems that my company is using and I have to extract the Datamodels behind these systems.
One of these systems is developed with a MSSQL server backend. Now I have to open this server tables and see the table structures and data directly how we see in Access.
Please help me by telling the way to open this database.
any help is very much appreciated.

:) thanks in advance.

View 4 Replies View Related

Running SQL Server 2000 And 2005 On The Same Computer

Nov 4, 2005

Does anyone know whether or not both versions can be installed on the same machine?

View 1 Replies View Related

How To Check Using If SQL Server Is Running On A Remote Computer

Jan 21, 2004

I am about designing an access project file that connect to a SQL Server database : it could be either on the local computer or a remote workstation, this depending on where the front end is running.

Bypassing the default log on dialog box i have set my own form that users should use to connect on adp. Then using baseconnection string i connect the adp to sql server database.

My concern is how can i check from vba if the instance of SQL Server where my back end database is located is running in order to make
users knowing that due sql server service status off their connection
tentative will fail.

inform u i can check same from console management however i would to automate same controle from my adp and avoid that users have to operate such task...

View 4 Replies View Related

Copy Files From Another Server To Computer With Robocopy And Job

Feb 4, 2015

I have one job for copy files from another server to my computer using Robocopy.but when I execute my job in sql server I get this error:

Accessing Source Directory 192.168.101.191Upload
Access is denied.
this is my job:
USE [msdb]
GO

/****** Object: Job [Test] Script Date: 02/04/2015 13:08:00 ******/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/****** Object: JobCategory [[Uncategorized (Local)]]] Script Date: 02/04/2015 13:08:00 ******/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)

[Code] ....

Should I create Credential and proxy?How can I do this?Would you mind giving me required scripts for this?

View 2 Replies View Related

Conecting To Report Server On A Remote Computer

Apr 7, 2008



Hello,
i'v installed a pogram that uses SQLEXpress and reporting sevices on a clients computer. I can acces the reports wih http://localhost/reports$SQLEXpress from that computer, but i can't reach them from other computers in the netwok by typing http://servername/reports$SQLEXpress
i am asked to imput a pasword for user "servername/guest" (which i do not know and dont think there is one) and then get the following:






You are not authorized to view this page

You do not have permission to view this directory or page using the credentials you supplied.





Please try the following:

Click the Refresh button to try again with different credentials.
If you believe you should be able to view this directory or page, please contact the Web site administrator by using the e-mail address or phone number listed on the preactor home page.
HTTP 401.3 - Access denied by ACL on resource
Internet Information Services
What should i do to solve this problem?

Regards
Darius

View 6 Replies View Related

Connecting On One Remote Computer But Not The Other On Sql Server 2005

Feb 15, 2007

I am unable to connect to a remote server on Computer A from Computer B, but when I reverse it I am able to connect to a remote server on computer B from computer A. I have SQL Server 2005 Developer Edition on both computers. I am using the using the SQL Management Studio to connect. Both Computers have these settings

Using Surface Area Configuration both have local and remote connections checked. Both computers using tcp/ip only checked.

Using Configuration Manager both the sql server and the sql browser are running. Both computers have tcp/ip protocols enabled.

Under the server properties on both computers, under the Security Tab, I have SQL Server and Windows Authentication Mode checked. Under the Connections tab I have Allow remote connections on this server checked.

I believe I have the Security for both the server and databases done properly giving them both proper Logins and User Roles with the proper permission.

Also went to my window firewall settings and under the Exceptions tab, I added both the sql server.exe and sql browser.exe programs on both computers on my remote network.

But when I connect on Computer B, I get an error message stating:

TITLE: Connect to Server
------------------------------

Cannot connect to 'ServerName'

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

------------------------------
BUTTONS:

OK
----------------------------



I tried pinging server a and then server b and they both pinged.



Could someone please tell me what could be wrong on my remote computers.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved