Showing posts with label business. Show all posts
Showing posts with label business. Show all posts

Thursday, March 22, 2012

Cant Access SQL Server (on Vista) from other Network PC (XP)

I have just installed Vista on one of my home network pcs. I also installed Outlook 2005 with Business Contact Manager. It installs an instance of SQL Server Express.

I have created another database on this engine that I need to access from other PCs on my network.

The server address is PCNAME\MSSMLBIZ and I can access the data the database using this name from the the Vista PC (PCNAME).

When I try to acess the database using the same credentials (server, database, username (sa) and password) from an XP PC on the network - it times out and returns an error . My guess is that it is not seeing the database service at all.

I have SQL Server Management Studio installed on the Vista PC and have full access to the instance.

Server authentication is set for SQL Server and Windows Authentication mode.

Can anyone help me?. I need to access the SQL Server from the XP PC.

Ian

Make sure that SQL Server Browser is running, you firewall is configured properly to allow the SQL Server traffic and that Remote connections are enabled for SQL Server. (See the screencats on my site for more information).

Firewall configuration: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b914277


Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Yes - that worked - as soon as I set remote access on Surface Area Configuration for Services and Connections page.

Regards Ian

|||I have just installed SQL Server 2005 Developer Edition on Windows Vista Ultimate, but i cant access and see "sql server managment studio" The only things i have are these >>>

Cant Access SQL Server (on Vista)

I have just installed Vista on one of my home network pcs. I also installed Outlook 2005 with Business Contact Manager. It installs an instance of SQL Server Express.

I have created another database on this engine that I need to access from other PCs on my network.

The server address is PCNAME\MSSMLBIZ and I can access the data the database using this name from the the Vista PC (PCNAME).

When I try to acess the database using the same credentials (server, database, username (sa) and password) from an XP PC on the network - it times out and returns an error . My guess is that it is not seeing the database service at all.

I have SQL Server Management Studio installed on the Vista PC and have full access to the instance.

Server authentication is set for SQL Server and Windows Authentication mode.

Can anyone help me?. I need to access the SQL Server from the XP PC.

Ian

Make sure that SQL Server Browser is running, you firewall is configured properly to allow the SQL Server traffic and that Remote connections are enabled for SQL Server. (See the screencats on my site for more information).

Firewall configuration: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b914277


Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Yes - that worked - as soon as I set remote access on Surface Area Configuration for Services and Connections page.

Regards Ian

|||I have just installed SQL Server 2005 Developer Edition on Windows Vista Ultimate, but i cant access and see "sql server managment studio" The only things i have are these >>>

Sunday, March 11, 2012

Cannot use Windows Authentication to connect to local Sql 2005

Hi,
I am building my workstation again, freshly installing everything.
The OS is Vista Business, 32 bit. I've installed Sql Server 2005
Developer Edition fine and applied service pack 2 successfully. It
seems to run fine, with one exception.
I can't logon using Windows Authentication. I'm a member of the Local
administrators group (as well as a Domain admin), but my domain
\username gets a logon denied error. I can logon just fine with the
sa account, but I prefer Windows Authentication.
Any ideas?
Thanks
AndyAndy (andyj@.med-associates.com) writes:
> I am building my workstation again, freshly installing everything.
> The OS is Vista Business, 32 bit. I've installed Sql Server 2005
> Developer Edition fine and applied service pack 2 successfully. It
> seems to run fine, with one exception.
> I can't logon using Windows Authentication. I'm a member of the Local
> administrators group (as well as a Domain admin), but my domain
> \username gets a logon denied error. I can logon just fine with the
> sa account, but I prefer Windows Authentication.
Did you run the special Vista thing at the end of the SP2 setup? Keep in
mind that on Vista you are normally not admin, only if you request and
confirm. Either start Mgmt Studio with Run As Administrator, or - better -
add your Windows user as a long and grant it CONTROL SERVER.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Jul 12, 6:30 pm, Erland Sommarskog <esq...@.sommarskog.se> wrote:
> Did you run the special Vista thing at the end of the SP2 setup? Keep in
> mind that on Vista you are normally not admin, only if you request and
> confirm. Either start Mgmt Studio with Run As Administrator, or - better -
> add your Windows user as a long and grant it CONTROL SERVER.
Yes, I ran the provisioning tool. I added my user specifically and
granted connect and control server, that seems to have worked. I
thought I had tried something similar by adding domain admins, but
that didn't seem to work.
Thanks for the tip.
Andy

Saturday, February 25, 2012

Cannot Start SQL Server 2000 after installing Vista

Just installed the Vista Business Upgrade. Now I cannot start SQL Server 200
0
even though my Windows Authentication has not changed. The Service Manager
reports "Access Denied" when I try to start the server.
Do I need to reinstall the server or is there a workaround? I tried the SSMS
but had no success.
--
malcolmHi,
can you elaborate more, is you MSSQL service run under domain or local
account?...However you an use registry rebuild to rebuild sql server
instllation and accounts without effecting your databases.
Omar
"malcolm" wrote:

> Just installed the Vista Business Upgrade. Now I cannot start SQL Server 2
000
> even though my Windows Authentication has not changed. The Service Manager
> reports "Access Denied" when I try to start the server.
> Do I need to reinstall the server or is there a workaround? I tried the SS
MS
> but had no success.
> --
> malcolm|||malcolm (ramartower@.access312.com) writes:
> Just installed the Vista Business Upgrade. Now I cannot start SQL Server
> 2000 even though my Windows Authentication has not changed. The Service
> Manager reports "Access Denied" when I try to start the server.
> Do I need to reinstall the server or is there a workaround? I tried the
> SSMS but had no success.
You could try to start it from Computer Management, or run Service Manager
by running as Admin. I guess the first showstopper is the UAC. But the
more basic problem is that SQL 2000 is not supported on Vista, so you may
not get it work at all. If you need the databases, you will need to find
another machine with a different operating system, or upgrade to SQL 2005.
(And you need SP2 of SQL 2005 to run on Vista.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

cannot start SQL server

I was using SQL server service manager with no problem.
I've installed "Business Contact Manager" and now service manager cannot
connect to the server.
Thanks for any advise.
Is the problem that you cannot connect to sql server or that the service
itself cannot start. You can try starting the service through the services
MMC instead of through service manager, by going to:
start->run->services.msc, look for the MSSQLServer (or MSSQL$INSTANCENAME)
service and do a right click->start.
What error are you seeing?
You can check this KB for some suggestions on how to troubleshoot SQL
connectivity:
How to troubleshoot connectivity issues in SQL Server 2000 - ID: 827422
http://support.microsoft.com/?id=827422
Also, check the latest SQL Error logs (c:\program files\microsoft sql
server\mssql\LOG\errorlog - the file with no extension is the latest sql
errorlog) and the application system event logs (in event viewer) for any
errors which occur during the time you attempted to start the SQL Service.
HTH,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

cannot start SQL server

I was using SQL server service manager with no problem.
I've installed "Business Contact Manager" and now service manager cannot
connect to the server.
Thanks for any advise.Is the problem that you cannot connect to sql server or that the service
itself cannot start. You can try starting the service through the services
MMC instead of through service manager, by going to:
start->run->services.msc, look for the MSSQLServer (or MSSQL$INSTANCENAME)
service and do a right click->start.
What error are you seeing?
You can check this KB for some suggestions on how to troubleshoot SQL
connectivity:
How to troubleshoot connectivity issues in SQL Server 2000 - ID: 827422
http://support.microsoft.com/?id=827422
Also, check the latest SQL Error logs (c:\program files\microsoft sql
server\mssql\LOG\errorlog - the file with no extension is the latest sql
errorlog) and the application system event logs (in event viewer) for any
errors which occur during the time you attempted to start the SQL Service.
HTH,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Tuesday, February 14, 2012

Cannot see index in Object Explorer on Replicated Database

I have replicated all the tables from the Business Data database to my instance of SQL Server 2005. They did not create primary keys on the tables, so I am adding them on the replicated database. I was trying to save one of the tables after adding a new primary key and got this error message:

'BuildingValues' table
- Unable to create index 'PK_BuildingValues'. CREATE UNIQUE INDEX terminated because a duplicate key was found for object name 'dbo.BuildingValues' and index name 'PK_BuildingValues'. The duplicate key value is (2). Could not create constraint. See previous errors. The statement has been terminated.

The problem is that there is nothing displayed in the Indexes folder for this table in Object Viewer (or any of the other folders for this table), so how would I know an index already existed? The index shows up for this table on the Publisher database, but not the Replicated database. Is this normal?

Sounds like you only replicated the data over without transfering other objects (i.e. pk, constraints, indexes, etc.). The error here is that your current data is not qualified for a pk constraint - pk creates an unique key/constraint underneath, thus, the values cannot be duplicated.
To find the dupes, try:
select [your_pk_col]
from tb
group by [your_pk_col]
having count(*)>1
Resolve that and you should be able to create your pk.
Indexes should get created on the subscriber if you configure it during publication creation - go to the object properties.|||

Thank you very much for your answer. The articles at the Publisher were configured to replicate all the keys and constraints to the Subscriber. You were right about the cause of the problem. The index could not be created, because of duplicate values in the column on the Subscriber. Once I added another column to make it unique, the primary key worked fine. Thanks again.