I am not able to edit tables through MS Access grid that is linked to sql
server 2000. I am able to edit some tables but not all.
Can you please tell me how I could change this so that I am able to edit all
the tables.
Thanks
> I am not able to edit tables through MS Access grid that is linked to sql
> server 2000. I am able to edit some tables but not all.
> Can you please tell me how I could change this so that I am able to edit
all
> the tables.
I guess you don't have Primary Key constraints on tables you cannot modify.
Check this first.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts
Tuesday, March 27, 2012
Cannot edit MS Access tables that are linked to SQL Server 2000
I am not able to edit tables through MS Access grid that is linked to sql
server 2000. I am able to edit some tables but not all.
Can you please tell me how I could change this so that I am able to edit all
the tables.
Thanks> I am not able to edit tables through MS Access grid that is linked to sql
> server 2000. I am able to edit some tables but not all.
> Can you please tell me how I could change this so that I am able to edit
all
> the tables.
I guess you don't have Primary Key constraints on tables you cannot modify.
Check this first.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
server 2000. I am able to edit some tables but not all.
Can you please tell me how I could change this so that I am able to edit all
the tables.
Thanks> I am not able to edit tables through MS Access grid that is linked to sql
> server 2000. I am able to edit some tables but not all.
> Can you please tell me how I could change this so that I am able to edit
all
> the tables.
I guess you don't have Primary Key constraints on tables you cannot modify.
Check this first.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
Sunday, March 25, 2012
Cannot drop the table "xyz" as it is being used for replication
I have a replication setup running on 2 Win2K Server PCs with SQL
Server 2000.
Both the PCs have a common DB installed on them.
The setup takes care of starting one PC as primary and other as
backup.
It also starts the SQL replication (transactional), where both the PCs
are configured as publisher, distributor and subscriber.
Now the replication service creates a publication ONLY ON
PRIMARY and a subscription ONLY ON BACKUP. The replication starts.
When a switch-over of primary and backup is done, the existing
publication and subscription are deleted. A new publication is created
on new PRIMARY and a new subscription on the new BACKUP. Again,
replication works without a problem.
HOWEVER, sometimes, (I'm not able to reproduce & it is very
infrequent) on a switch-over I get thee error--"Cannot drop the table
"xyz" as it is being used for replication." The table is the one I
used for replication. Also, the primary keys exist on this table in
this case even though it's a part of subscription. The only solution
till now is to delete the entire replication on both machines and
re-create it.
I'm not using this DB anywhere else for any other purpose. Any
clues, why am I getting this problem occasionaly?
Thanks in advance.
Nelabh,
it's sometimes the case that some replication metadata is left hanging
around in system tables. sp_removedbreplication usually fixes these issues,
or the more granular sp_MSunmarkreplinfo may also be of interest.
HTH,
Paul Ibison
Server 2000.
Both the PCs have a common DB installed on them.
The setup takes care of starting one PC as primary and other as
backup.
It also starts the SQL replication (transactional), where both the PCs
are configured as publisher, distributor and subscriber.
Now the replication service creates a publication ONLY ON
PRIMARY and a subscription ONLY ON BACKUP. The replication starts.
When a switch-over of primary and backup is done, the existing
publication and subscription are deleted. A new publication is created
on new PRIMARY and a new subscription on the new BACKUP. Again,
replication works without a problem.
HOWEVER, sometimes, (I'm not able to reproduce & it is very
infrequent) on a switch-over I get thee error--"Cannot drop the table
"xyz" as it is being used for replication." The table is the one I
used for replication. Also, the primary keys exist on this table in
this case even though it's a part of subscription. The only solution
till now is to delete the entire replication on both machines and
re-create it.
I'm not using this DB anywhere else for any other purpose. Any
clues, why am I getting this problem occasionaly?
Thanks in advance.
Nelabh,
it's sometimes the case that some replication metadata is left hanging
around in system tables. sp_removedbreplication usually fixes these issues,
or the more granular sp_MSunmarkreplinfo may also be of interest.
HTH,
Paul Ibison
Tuesday, March 20, 2012
cannot delete duplicated records
the servers i have is like that:
SERV-A is publisher,
SERV-B is subscribor to SERV-A
SERV-C is subscribor to SERV-B
I have sqlserver which the database on it is configured as publisher and
subscribor at the same time, I have duplicate record in a specific table on
that server only(SERV-B), when i tried to delete these records it give the
following message "cannot insert dublicate keyrow in object
msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement has
been terminated".
why this message appear and how i can delete these records?
thanks in advance.
Samir R. Ibrahim
run the merge agent on the publisher and subscriber/publisher. After it has
completed check the conflict viewer on both the publisher and
publisher/subscriber.
Hopefully the problem row will be in one of these tables and you can delete
it there.
"Samir R. Ibrahim" <samir.ibrahim@.wilcopm.com> wrote in message
news:OvWvIw3KEHA.556@.TK2MSFTNGP10.phx.gbl...
> the servers i have is like that:
> SERV-A is publisher,
> SERV-B is subscribor to SERV-A
> SERV-C is subscribor to SERV-B
> I have sqlserver which the database on it is configured as publisher and
> subscribor at the same time, I have duplicate record in a specific table
on
> that server only(SERV-B), when i tried to delete these records it give the
> following message "cannot insert dublicate keyrow in object
> msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement
has
> been terminated".
> why this message appear and how i can delete these records?
> thanks in advance.
> Samir R. Ibrahim
>
>
SERV-A is publisher,
SERV-B is subscribor to SERV-A
SERV-C is subscribor to SERV-B
I have sqlserver which the database on it is configured as publisher and
subscribor at the same time, I have duplicate record in a specific table on
that server only(SERV-B), when i tried to delete these records it give the
following message "cannot insert dublicate keyrow in object
msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement has
been terminated".
why this message appear and how i can delete these records?
thanks in advance.
Samir R. Ibrahim
run the merge agent on the publisher and subscriber/publisher. After it has
completed check the conflict viewer on both the publisher and
publisher/subscriber.
Hopefully the problem row will be in one of these tables and you can delete
it there.
"Samir R. Ibrahim" <samir.ibrahim@.wilcopm.com> wrote in message
news:OvWvIw3KEHA.556@.TK2MSFTNGP10.phx.gbl...
> the servers i have is like that:
> SERV-A is publisher,
> SERV-B is subscribor to SERV-A
> SERV-C is subscribor to SERV-B
> I have sqlserver which the database on it is configured as publisher and
> subscribor at the same time, I have duplicate record in a specific table
on
> that server only(SERV-B), when i tried to delete these records it give the
> following message "cannot insert dublicate keyrow in object
> msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement
has
> been terminated".
> why this message appear and how i can delete these records?
> thanks in advance.
> Samir R. Ibrahim
>
>
cannot delete dupliacted records.
the servers i have is like that:
SERV-A is publisher,
SERV-B is subscribor to SERV-A
SERV-C is subscribor to SERV-B
I have sqlserver which the database on it is configured as publisher and
subscribor at the same time, I have duplicate record in a specific table on
that server only(SERV-B), when i tried to delete these records it give the
following message "cannot insert dublicate keyrow in object
msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement has
been terminated".
why this message appear and how i can delete these records?
thanks in advance.
Samir R. Ibrahim
>
> the servers i have is like that:
> SERV-A is publisher,
> SERV-B is subscribor to SERV-A
> SERV-C is subscribor to SERV-B
> I have sqlserver which the database on it is configured as publisher and
> subscribor at the same time, I have duplicate record in a specific table
on
> that server only(SERV-B), when i tried to delete these records it give the
> following message "cannot insert dublicate keyrow in object
> msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement
has
> been terminated".
> why this message appear and how i can delete these records?
> thanks in advance.
> Samir R. Ibrahim
Hi Samir,
This information might help:
INF: Understanding Merge Replication Conflict Detection and Resolution
http://support.microsoft.com/?id=315514
Regards,
Eric Crdenas
SQL Server senior support professional
SERV-A is publisher,
SERV-B is subscribor to SERV-A
SERV-C is subscribor to SERV-B
I have sqlserver which the database on it is configured as publisher and
subscribor at the same time, I have duplicate record in a specific table on
that server only(SERV-B), when i tried to delete these records it give the
following message "cannot insert dublicate keyrow in object
msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement has
been terminated".
why this message appear and how i can delete these records?
thanks in advance.
Samir R. Ibrahim
>
> the servers i have is like that:
> SERV-A is publisher,
> SERV-B is subscribor to SERV-A
> SERV-C is subscribor to SERV-B
> I have sqlserver which the database on it is configured as publisher and
> subscribor at the same time, I have duplicate record in a specific table
on
> that server only(SERV-B), when i tried to delete these records it give the
> following message "cannot insert dublicate keyrow in object
> msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement
has
> been terminated".
> why this message appear and how i can delete these records?
> thanks in advance.
> Samir R. Ibrahim
Hi Samir,
This information might help:
INF: Understanding Merge Replication Conflict Detection and Resolution
http://support.microsoft.com/?id=315514
Regards,
Eric Crdenas
SQL Server senior support professional
cannot delete dupliacted records.
the servers i have is like that:
SERV-A is publisher,
SERV-B is subscribor to SERV-A
SERV-C is subscribor to SERV-B
I have sqlserver which the database on it is configured as publisher and
subscribor at the same time, I have duplicate record in a specific table on
that server only(SERV-B), when i tried to delete these records it give the
following message "cannot insert dublicate keyrow in object
msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement has
been terminated".
why this message appear and how i can delete these records?
thanks in advance.
Samir R. Ibrahim>
> the servers i have is like that:
> SERV-A is publisher,
> SERV-B is subscribor to SERV-A
> SERV-C is subscribor to SERV-B
> I have sqlserver which the database on it is configured as publisher and
> subscribor at the same time, I have duplicate record in a specific table
on
> that server only(SERV-B), when i tried to delete these records it give the
> following message "cannot insert dublicate keyrow in object
> msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement
has
> been terminated".
> why this message appear and how i can delete these records?
> thanks in advance.
> Samir R. Ibrahim
--
Hi Samir,
This information might help:
INF: Understanding Merge Replication Conflict Detection and Resolution
http://support.microsoft.com/?id=315514
Regards,
Eric Crdenas
SQL Server senior support professional
SERV-A is publisher,
SERV-B is subscribor to SERV-A
SERV-C is subscribor to SERV-B
I have sqlserver which the database on it is configured as publisher and
subscribor at the same time, I have duplicate record in a specific table on
that server only(SERV-B), when i tried to delete these records it give the
following message "cannot insert dublicate keyrow in object
msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement has
been terminated".
why this message appear and how i can delete these records?
thanks in advance.
Samir R. Ibrahim>
> the servers i have is like that:
> SERV-A is publisher,
> SERV-B is subscribor to SERV-A
> SERV-C is subscribor to SERV-B
> I have sqlserver which the database on it is configured as publisher and
> subscribor at the same time, I have duplicate record in a specific table
on
> that server only(SERV-B), when i tried to delete these records it give the
> following message "cannot insert dublicate keyrow in object
> msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement
has
> been terminated".
> why this message appear and how i can delete these records?
> thanks in advance.
> Samir R. Ibrahim
--
Hi Samir,
This information might help:
INF: Understanding Merge Replication Conflict Detection and Resolution
http://support.microsoft.com/?id=315514
Regards,
Eric Crdenas
SQL Server senior support professional
cannot delete dupliacted records.
the servers i have is like that:
SERV-A is publisher,
SERV-B is subscribor to SERV-A
SERV-C is subscribor to SERV-B
I have sqlserver which the database on it is configured as publisher and
subscribor at the same time, I have duplicate record in a specific table on
that server only(SERV-B), when i tried to delete these records it give the
following message "cannot insert dublicate keyrow in object
msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement has
been terminated".
why this message appear and how i can delete these records?
thanks in advance.
Samir R. Ibrahim>
> the servers i have is like that:
> SERV-A is publisher,
> SERV-B is subscribor to SERV-A
> SERV-C is subscribor to SERV-B
> I have sqlserver which the database on it is configured as publisher and
> subscribor at the same time, I have duplicate record in a specific table
on
> that server only(SERV-B), when i tried to delete these records it give the
> following message "cannot insert dublicate keyrow in object
> msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement
has
> been terminated".
> why this message appear and how i can delete these records?
> thanks in advance.
> Samir R. Ibrahim
--
Hi Samir,
This information might help:
INF: Understanding Merge Replication Conflict Detection and Resolution
http://support.microsoft.com/?id=315514
Regards,
--
Eric Cárdenas
SQL Server senior support professional
SERV-A is publisher,
SERV-B is subscribor to SERV-A
SERV-C is subscribor to SERV-B
I have sqlserver which the database on it is configured as publisher and
subscribor at the same time, I have duplicate record in a specific table on
that server only(SERV-B), when i tried to delete these records it give the
following message "cannot insert dublicate keyrow in object
msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement has
been terminated".
why this message appear and how i can delete these records?
thanks in advance.
Samir R. Ibrahim>
> the servers i have is like that:
> SERV-A is publisher,
> SERV-B is subscribor to SERV-A
> SERV-C is subscribor to SERV-B
> I have sqlserver which the database on it is configured as publisher and
> subscribor at the same time, I have duplicate record in a specific table
on
> that server only(SERV-B), when i tried to delete these records it give the
> following message "cannot insert dublicate keyrow in object
> msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement
has
> been terminated".
> why this message appear and how i can delete these records?
> thanks in advance.
> Samir R. Ibrahim
--
Hi Samir,
This information might help:
INF: Understanding Merge Replication Conflict Detection and Resolution
http://support.microsoft.com/?id=315514
Regards,
--
Eric Cárdenas
SQL Server senior support professional
Monday, March 19, 2012
Cannot create merge replication from SQLSERVER 2000 to ORACLE
Hello everybody,
I am trying to build a merge replication between 2 servers
i managed to create it between to SQLSERVER 2000 with no problem
but now i am trying to do it between SQLSERVER 2000 and ORACLE server
when i try to do a transactional replication it work fine between the two
servers
but when i try to do the merge replication the following error occur:
The step did not generate any output. The step failed
i searched the topics and did not find any help but i managed to try writing
the output error on a file and it gave me the following message:
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: CARLO-testrep-testrep-OLINK-1
Category:NULL
Source: Merge Process
Number: -2147200933
Message: The process could not load the Merge Replication Provider for
'Oracle'. Check to see if the component is registered correctly.
if anyone can help me with, please do
best Regards
Nicolas
This is not supported, you can only replicate to SQL Server, MSAcess and SQL
CE. You will have to cobble a solution together for this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nicolas Akl" <c_khano@.hotmail.com> wrote in message
news:D66DB88D-29E0-449B-B578-D775BFDD2572@.microsoft.com...
> Hello everybody,
> I am trying to build a merge replication between 2 servers
> i managed to create it between to SQLSERVER 2000 with no problem
> but now i am trying to do it between SQLSERVER 2000 and ORACLE server
> when i try to do a transactional replication it work fine between the two
> servers
> but when i try to do the merge replication the following error occur:
> The step did not generate any output. The step failed
> i searched the topics and did not find any help but i managed to try
writing
> the output error on a file and it gave me the following message:
> Microsoft SQL Server Merge Agent 8.00.760
> Copyright (c) 2000 Microsoft Corporation
> Microsoft SQL Server Replication Agent: CARLO-testrep-testrep-OLINK-1
> Category:NULL
> Source: Merge Process
> Number: -2147200933
> Message: The process could not load the Merge Replication Provider for
> 'Oracle'. Check to see if the component is registered correctly.
> if anyone can help me with, please do
> best Regards
> Nicolas
|||Dear Hilary,
As i understand from you, that there is no way to make a merge
replication from sqlserver 2000 to Oracle,
if so why does it support transactional replication and not the merge
replication
Best Regards
Carlo khanati.
I am trying to build a merge replication between 2 servers
i managed to create it between to SQLSERVER 2000 with no problem
but now i am trying to do it between SQLSERVER 2000 and ORACLE server
when i try to do a transactional replication it work fine between the two
servers
but when i try to do the merge replication the following error occur:
The step did not generate any output. The step failed
i searched the topics and did not find any help but i managed to try writing
the output error on a file and it gave me the following message:
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: CARLO-testrep-testrep-OLINK-1
Category:NULL
Source: Merge Process
Number: -2147200933
Message: The process could not load the Merge Replication Provider for
'Oracle'. Check to see if the component is registered correctly.
if anyone can help me with, please do
best Regards
Nicolas
This is not supported, you can only replicate to SQL Server, MSAcess and SQL
CE. You will have to cobble a solution together for this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nicolas Akl" <c_khano@.hotmail.com> wrote in message
news:D66DB88D-29E0-449B-B578-D775BFDD2572@.microsoft.com...
> Hello everybody,
> I am trying to build a merge replication between 2 servers
> i managed to create it between to SQLSERVER 2000 with no problem
> but now i am trying to do it between SQLSERVER 2000 and ORACLE server
> when i try to do a transactional replication it work fine between the two
> servers
> but when i try to do the merge replication the following error occur:
> The step did not generate any output. The step failed
> i searched the topics and did not find any help but i managed to try
writing
> the output error on a file and it gave me the following message:
> Microsoft SQL Server Merge Agent 8.00.760
> Copyright (c) 2000 Microsoft Corporation
> Microsoft SQL Server Replication Agent: CARLO-testrep-testrep-OLINK-1
> Category:NULL
> Source: Merge Process
> Number: -2147200933
> Message: The process could not load the Merge Replication Provider for
> 'Oracle'. Check to see if the component is registered correctly.
> if anyone can help me with, please do
> best Regards
> Nicolas
|||Dear Hilary,
As i understand from you, that there is no way to make a merge
replication from sqlserver 2000 to Oracle,
if so why does it support transactional replication and not the merge
replication
Best Regards
Carlo khanati.
Cannot create diagrams in SQLSERVER 2005
Hi,
Every time I click on the Database Diagram node in object explorer in SQL
Server Management Studio, I get a message:
Database diagram support objects cannot be installed because this database
does not have a valid owner. ...
I have checked the owner and it coincides with my logon name in my domain
(i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
problem with Active Directory? Why am I not being recognized as a valid db
owner?
Thanks in advance,
Juan Dent, M.Sc.
Make sure the compatibility level of the databases is set to
90 - that's often what causes the problem.
You can set it to 90 using:
EXEC sp_dbcmptlevel 'database name', '90'
-Sue
On Mon, 23 Jan 2006 17:04:01 -0800, Juan Dent
<Juan_Dent@.nospam.nospam> wrote:
>Hi,
>Every time I click on the Database Diagram node in object explorer in SQL
>Server Management Studio, I get a message:
> Database diagram support objects cannot be installed because this database
>does not have a valid owner. ...
>I have checked the owner and it coincides with my logon name in my domain
>(i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
>problem with Active Directory? Why am I not being recognized as a valid db
>owner?
|||Juan Dent (Juan_Dent@.nospam.nospam) writes:
> Every time I click on the Database Diagram node in object explorer in SQL
> Server Management Studio, I get a message:
> Database diagram support objects cannot be installed because this
> database does not have a valid owner. ...
> I have checked the owner and it coincides with my logon name in my domain
> (i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
> problem with Active Directory? Why am I not being recognized as a valid db
> owner?
This typically happens when you migrate a database from another server.
The problem can be seen by SELECT * FROM sys.database_principals. Compare
the row for dbo with a database created on the server.
I think changing the ownership to some other login, and back to yourself
fixes the issues.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||This site will help. There are two quick steps.
http://mcfunley.com/cs/blogs/dan/arc...12/23/899.aspx
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
Every time I click on the Database Diagram node in object explorer in SQL
Server Management Studio, I get a message:
Database diagram support objects cannot be installed because this database
does not have a valid owner. ...
I have checked the owner and it coincides with my logon name in my domain
(i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
problem with Active Directory? Why am I not being recognized as a valid db
owner?
Thanks in advance,
Juan Dent, M.Sc.
Make sure the compatibility level of the databases is set to
90 - that's often what causes the problem.
You can set it to 90 using:
EXEC sp_dbcmptlevel 'database name', '90'
-Sue
On Mon, 23 Jan 2006 17:04:01 -0800, Juan Dent
<Juan_Dent@.nospam.nospam> wrote:
>Hi,
>Every time I click on the Database Diagram node in object explorer in SQL
>Server Management Studio, I get a message:
> Database diagram support objects cannot be installed because this database
>does not have a valid owner. ...
>I have checked the owner and it coincides with my logon name in my domain
>(i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
>problem with Active Directory? Why am I not being recognized as a valid db
>owner?
|||Juan Dent (Juan_Dent@.nospam.nospam) writes:
> Every time I click on the Database Diagram node in object explorer in SQL
> Server Management Studio, I get a message:
> Database diagram support objects cannot be installed because this
> database does not have a valid owner. ...
> I have checked the owner and it coincides with my logon name in my domain
> (i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
> problem with Active Directory? Why am I not being recognized as a valid db
> owner?
This typically happens when you migrate a database from another server.
The problem can be seen by SELECT * FROM sys.database_principals. Compare
the row for dbo with a database created on the server.
I think changing the ownership to some other login, and back to yourself
fixes the issues.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||This site will help. There are two quick steps.
http://mcfunley.com/cs/blogs/dan/arc...12/23/899.aspx
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
Thursday, March 8, 2012
Cannot create a new instance in sqlserver 2005
I have installed sqlserver 2005 and by mistake i have made a default instance. I previously had sqlserver 2000 installed on my machine. Now I want to create a new instance of sqlserver 2005 but dont know how to do it .... Please help me on thisInsert the setup media and simply install another instance. Make sure that you applay the service pack afterwards, because the service pack level is maitained per instance.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Saturday, February 25, 2012
Cannot connect via Web Application...
I am using SQLServer 2000, Visual Studio 2003, C#.
I am writing a web part which requires me to connect to a local sql
database.
I wrote a class which handles the connection and reading of the table.
When I try to call .Open on the connection, it fails, the exception is
something to do with permission.
I used the same class to connect with a console application and a
windows application, and it works fine. I am able to connect and read
the table.
Can anyone shed some light on what is the difference between
connecting/accessing to a database via Web Application as opposed to a
Non-Web App.
TIAI think your problem has something to do with permission as the error
indicates. If you are writing an ASP.Net web page then your web application
is running as the ASPUSER Windows user and chances are this use does not
have permissions to connect to the database. When you run as a Windows
application you run as you and you probably have admin permissions on the
box which gives you SA permissions in the database so you can do whatever
you want. Confirm that you are running as ASPUSER and then create a login
and user for it in SQL Server.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
news:1168476873.734347.313800@.k58g2000hse.googlegroups.com...
>I am using SQLServer 2000, Visual Studio 2003, C#.
> I am writing a web part which requires me to connect to a local sql
> database.
> I wrote a class which handles the connection and reading of the table.
> When I try to call .Open on the connection, it fails, the exception is
> something to do with permission.
> I used the same class to connect with a console application and a
> windows application, and it works fine. I am able to connect and read
> the table.
> Can anyone shed some light on what is the difference between
> connecting/accessing to a database via Web Application as opposed to a
> Non-Web App.
> TIA
>|||Roger,
Thanks for the reply.
I ran SQL Server Enterprise Manager and for that database, I checked
the Users.
there are two, dbo and guest, both having full permissions.
How would I confirm tthat I am running as ASPUSER and create a login
for it?
Thanks,
IV
Roger Wolter[MSFT] wrote:[vbcol=seagreen]
> I think your problem has something to do with permission as the error
> indicates. If you are writing an ASP.Net web page then your web applicati
on
> is running as the ASPUSER Windows user and chances are this use does not
> have permissions to connect to the database. When you run as a Windows
> application you run as you and you probably have admin permissions on the
> box which gives you SA permissions in the database so you can do whatever
> you want. Confirm that you are running as ASPUSER and then create a login
> and user for it in SQL Server.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
> news:1168476873.734347.313800@.k58g2000hse.googlegroups.com...|||Log in as an admin. USE the database where your tables are and execute
these commands (substituting the name of you machine for servername)
CREATE LOGIN [servername\ASPNET] FROM WINDOWS
CREATE USER [servername\ASPNET] FROM LOGIN [servername\ASPNET]
http://msdn2.microsoft.com/en-us/library/ms189751.aspx
http://msdn2.microsoft.com/en-us/library/ms173463.aspx
You will then have to grant this user access to the objects it needs to
access for your application
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
news:1168487427.667116.147270@.p59g2000hsd.googlegroups.com...
> Roger,
> Thanks for the reply.
> I ran SQL Server Enterprise Manager and for that database, I checked
> the Users.
> there are two, dbo and guest, both having full permissions.
> How would I confirm tthat I am running as ASPUSER and create a login
> for it?
> Thanks,
> IV
> Roger Wolter[MSFT] wrote:
>|||Roger,
I appreciate you taking the time to help me out.
I tried what you said and am still failing with the same exception.
Imtiaz
Roger Wolter[MSFT] wrote:[vbcol=seagreen]
> Log in as an admin. USE the database where your tables are and execute
> these commands (substituting the name of you machine for servername)
> CREATE LOGIN [servername\ASPNET] FROM WINDOWS
> CREATE USER [servername\ASPNET] FROM LOGIN [servername\ASPNET]
> http://msdn2.microsoft.com/en-us/library/ms189751.aspx
> http://msdn2.microsoft.com/en-us/library/ms173463.aspx
> You will then have to grant this user access to the objects it needs to
> access for your application
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
> news:1168487427.667116.147270@.p59g2000hsd.googlegroups.com...
I am writing a web part which requires me to connect to a local sql
database.
I wrote a class which handles the connection and reading of the table.
When I try to call .Open on the connection, it fails, the exception is
something to do with permission.
I used the same class to connect with a console application and a
windows application, and it works fine. I am able to connect and read
the table.
Can anyone shed some light on what is the difference between
connecting/accessing to a database via Web Application as opposed to a
Non-Web App.
TIAI think your problem has something to do with permission as the error
indicates. If you are writing an ASP.Net web page then your web application
is running as the ASPUSER Windows user and chances are this use does not
have permissions to connect to the database. When you run as a Windows
application you run as you and you probably have admin permissions on the
box which gives you SA permissions in the database so you can do whatever
you want. Confirm that you are running as ASPUSER and then create a login
and user for it in SQL Server.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
news:1168476873.734347.313800@.k58g2000hse.googlegroups.com...
>I am using SQLServer 2000, Visual Studio 2003, C#.
> I am writing a web part which requires me to connect to a local sql
> database.
> I wrote a class which handles the connection and reading of the table.
> When I try to call .Open on the connection, it fails, the exception is
> something to do with permission.
> I used the same class to connect with a console application and a
> windows application, and it works fine. I am able to connect and read
> the table.
> Can anyone shed some light on what is the difference between
> connecting/accessing to a database via Web Application as opposed to a
> Non-Web App.
> TIA
>|||Roger,
Thanks for the reply.
I ran SQL Server Enterprise Manager and for that database, I checked
the Users.
there are two, dbo and guest, both having full permissions.
How would I confirm tthat I am running as ASPUSER and create a login
for it?
Thanks,
IV
Roger Wolter[MSFT] wrote:[vbcol=seagreen]
> I think your problem has something to do with permission as the error
> indicates. If you are writing an ASP.Net web page then your web applicati
on
> is running as the ASPUSER Windows user and chances are this use does not
> have permissions to connect to the database. When you run as a Windows
> application you run as you and you probably have admin permissions on the
> box which gives you SA permissions in the database so you can do whatever
> you want. Confirm that you are running as ASPUSER and then create a login
> and user for it in SQL Server.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
> news:1168476873.734347.313800@.k58g2000hse.googlegroups.com...|||Log in as an admin. USE the database where your tables are and execute
these commands (substituting the name of you machine for servername)
CREATE LOGIN [servername\ASPNET] FROM WINDOWS
CREATE USER [servername\ASPNET] FROM LOGIN [servername\ASPNET]
http://msdn2.microsoft.com/en-us/library/ms189751.aspx
http://msdn2.microsoft.com/en-us/library/ms173463.aspx
You will then have to grant this user access to the objects it needs to
access for your application
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
news:1168487427.667116.147270@.p59g2000hsd.googlegroups.com...
> Roger,
> Thanks for the reply.
> I ran SQL Server Enterprise Manager and for that database, I checked
> the Users.
> there are two, dbo and guest, both having full permissions.
> How would I confirm tthat I am running as ASPUSER and create a login
> for it?
> Thanks,
> IV
> Roger Wolter[MSFT] wrote:
>|||Roger,
I appreciate you taking the time to help me out.
I tried what you said and am still failing with the same exception.
Imtiaz
Roger Wolter[MSFT] wrote:[vbcol=seagreen]
> Log in as an admin. USE the database where your tables are and execute
> these commands (substituting the name of you machine for servername)
> CREATE LOGIN [servername\ASPNET] FROM WINDOWS
> CREATE USER [servername\ASPNET] FROM LOGIN [servername\ASPNET]
> http://msdn2.microsoft.com/en-us/library/ms189751.aspx
> http://msdn2.microsoft.com/en-us/library/ms173463.aspx
> You will then have to grant this user access to the objects it needs to
> access for your application
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
> news:1168487427.667116.147270@.p59g2000hsd.googlegroups.com...
Cannot connect via Web Application...
I am using SQLServer 2000, Visual Studio 2003, C#.
I am writing a web part which requires me to connect to a local sql
database.
I wrote a class which handles the connection and reading of the table.
When I try to call .Open on the connection, it fails, the exception is
something to do with permission.
I used the same class to connect with a console application and a
windows application, and it works fine. I am able to connect and read
the table.
Can anyone shed some light on what is the difference between
connecting/accessing to a database via Web Application as opposed to a
Non-Web App.
TIA
I think your problem has something to do with permission as the error
indicates. If you are writing an ASP.Net web page then your web application
is running as the ASPUSER Windows user and chances are this use does not
have permissions to connect to the database. When you run as a Windows
application you run as you and you probably have admin permissions on the
box which gives you SA permissions in the database so you can do whatever
you want. Confirm that you are running as ASPUSER and then create a login
and user for it in SQL Server.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
news:1168476873.734347.313800@.k58g2000hse.googlegr oups.com...
>I am using SQLServer 2000, Visual Studio 2003, C#.
> I am writing a web part which requires me to connect to a local sql
> database.
> I wrote a class which handles the connection and reading of the table.
> When I try to call .Open on the connection, it fails, the exception is
> something to do with permission.
> I used the same class to connect with a console application and a
> windows application, and it works fine. I am able to connect and read
> the table.
> Can anyone shed some light on what is the difference between
> connecting/accessing to a database via Web Application as opposed to a
> Non-Web App.
> TIA
>
|||Roger,
Thanks for the reply.
I ran SQL Server Enterprise Manager and for that database, I checked
the Users.
there are two, dbo and guest, both having full permissions.
How would I confirm tthat I am running as ASPUSER and create a login
for it?
Thanks,
IV
Roger Wolter[MSFT] wrote:[vbcol=seagreen]
> I think your problem has something to do with permission as the error
> indicates. If you are writing an ASP.Net web page then your web application
> is running as the ASPUSER Windows user and chances are this use does not
> have permissions to connect to the database. When you run as a Windows
> application you run as you and you probably have admin permissions on the
> box which gives you SA permissions in the database so you can do whatever
> you want. Confirm that you are running as ASPUSER and then create a login
> and user for it in SQL Server.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
> news:1168476873.734347.313800@.k58g2000hse.googlegr oups.com...
|||Log in as an admin. USE the database where your tables are and execute
these commands (substituting the name of you machine for servername)
CREATE LOGIN [servername\ASPNET] FROM WINDOWS
CREATE USER [servername\ASPNET] FROM LOGIN [servername\ASPNET]
http://msdn2.microsoft.com/en-us/library/ms189751.aspx
http://msdn2.microsoft.com/en-us/library/ms173463.aspx
You will then have to grant this user access to the objects it needs to
access for your application
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
news:1168487427.667116.147270@.p59g2000hsd.googlegr oups.com...
> Roger,
> Thanks for the reply.
> I ran SQL Server Enterprise Manager and for that database, I checked
> the Users.
> there are two, dbo and guest, both having full permissions.
> How would I confirm tthat I am running as ASPUSER and create a login
> for it?
> Thanks,
> IV
> Roger Wolter[MSFT] wrote:
>
|||Roger,
I appreciate you taking the time to help me out.
I tried what you said and am still failing with the same exception.
Imtiaz
Roger Wolter[MSFT] wrote:[vbcol=seagreen]
> Log in as an admin. USE the database where your tables are and execute
> these commands (substituting the name of you machine for servername)
> CREATE LOGIN [servername\ASPNET] FROM WINDOWS
> CREATE USER [servername\ASPNET] FROM LOGIN [servername\ASPNET]
> http://msdn2.microsoft.com/en-us/library/ms189751.aspx
> http://msdn2.microsoft.com/en-us/library/ms173463.aspx
> You will then have to grant this user access to the objects it needs to
> access for your application
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
> news:1168487427.667116.147270@.p59g2000hsd.googlegr oups.com...
I am writing a web part which requires me to connect to a local sql
database.
I wrote a class which handles the connection and reading of the table.
When I try to call .Open on the connection, it fails, the exception is
something to do with permission.
I used the same class to connect with a console application and a
windows application, and it works fine. I am able to connect and read
the table.
Can anyone shed some light on what is the difference between
connecting/accessing to a database via Web Application as opposed to a
Non-Web App.
TIA
I think your problem has something to do with permission as the error
indicates. If you are writing an ASP.Net web page then your web application
is running as the ASPUSER Windows user and chances are this use does not
have permissions to connect to the database. When you run as a Windows
application you run as you and you probably have admin permissions on the
box which gives you SA permissions in the database so you can do whatever
you want. Confirm that you are running as ASPUSER and then create a login
and user for it in SQL Server.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
news:1168476873.734347.313800@.k58g2000hse.googlegr oups.com...
>I am using SQLServer 2000, Visual Studio 2003, C#.
> I am writing a web part which requires me to connect to a local sql
> database.
> I wrote a class which handles the connection and reading of the table.
> When I try to call .Open on the connection, it fails, the exception is
> something to do with permission.
> I used the same class to connect with a console application and a
> windows application, and it works fine. I am able to connect and read
> the table.
> Can anyone shed some light on what is the difference between
> connecting/accessing to a database via Web Application as opposed to a
> Non-Web App.
> TIA
>
|||Roger,
Thanks for the reply.
I ran SQL Server Enterprise Manager and for that database, I checked
the Users.
there are two, dbo and guest, both having full permissions.
How would I confirm tthat I am running as ASPUSER and create a login
for it?
Thanks,
IV
Roger Wolter[MSFT] wrote:[vbcol=seagreen]
> I think your problem has something to do with permission as the error
> indicates. If you are writing an ASP.Net web page then your web application
> is running as the ASPUSER Windows user and chances are this use does not
> have permissions to connect to the database. When you run as a Windows
> application you run as you and you probably have admin permissions on the
> box which gives you SA permissions in the database so you can do whatever
> you want. Confirm that you are running as ASPUSER and then create a login
> and user for it in SQL Server.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
> news:1168476873.734347.313800@.k58g2000hse.googlegr oups.com...
|||Log in as an admin. USE the database where your tables are and execute
these commands (substituting the name of you machine for servername)
CREATE LOGIN [servername\ASPNET] FROM WINDOWS
CREATE USER [servername\ASPNET] FROM LOGIN [servername\ASPNET]
http://msdn2.microsoft.com/en-us/library/ms189751.aspx
http://msdn2.microsoft.com/en-us/library/ms173463.aspx
You will then have to grant this user access to the objects it needs to
access for your application
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
news:1168487427.667116.147270@.p59g2000hsd.googlegr oups.com...
> Roger,
> Thanks for the reply.
> I ran SQL Server Enterprise Manager and for that database, I checked
> the Users.
> there are two, dbo and guest, both having full permissions.
> How would I confirm tthat I am running as ASPUSER and create a login
> for it?
> Thanks,
> IV
> Roger Wolter[MSFT] wrote:
>
|||Roger,
I appreciate you taking the time to help me out.
I tried what you said and am still failing with the same exception.
Imtiaz
Roger Wolter[MSFT] wrote:[vbcol=seagreen]
> Log in as an admin. USE the database where your tables are and execute
> these commands (substituting the name of you machine for servername)
> CREATE LOGIN [servername\ASPNET] FROM WINDOWS
> CREATE USER [servername\ASPNET] FROM LOGIN [servername\ASPNET]
> http://msdn2.microsoft.com/en-us/library/ms189751.aspx
> http://msdn2.microsoft.com/en-us/library/ms173463.aspx
> You will then have to grant this user access to the objects it needs to
> access for your application
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "IV" <Imtiaz.Vohra@.vtechsr.com> wrote in message
> news:1168487427.667116.147270@.p59g2000hsd.googlegr oups.com...
Cannot connect to SQLServer2000
Hello everyone,
My project (asp.net and sqlserver2000) is working fine in my intranet. But sometime, it cannot connect to sqlserver, it shows "SQLServer does not exists or access denied". If I restart my dbserver and webserver, then it again works fine.Please give me a solution.
Hi,
"SQL Server does not exist or access denied" is a generic Microsoft Data Access Components (MDAC) message that indicates that the computer that is running Microsoft SQL Server cannot be contacted. Since your problem occurs radomly. So it has many potential causes, the following link may provide some detail information.
http://support.microsoft.com/kb/328306/en-us
Thanks.
Cannot connect to SQLServer 2005
After several attempts to install SQL2005 I finally got Microsoft SQL Server Management Studio installed.
But now I get the error below:
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) (.Net SqlClient Data Provider)
The sa account username/password are correct and don't work, windows authentication does not work, I have stopped/started all the services, I have all Protocols enabled correctly, I have my Firewall turned off.
Is there anything else I can try? Anything!
After 24 hours of looking at this, I just figured out the answer!!! ServerName\instance is needed for logging on!!Cannot Connect To SQL Server.
I'm relatively new to SQLServer. On one machine I have Access 2002
and the Developers edition of SQLServer 2000 and the Upsizing Wizard
works fine. On the other machine I have the same version of
SQLServer, but Access 2003. No matter what I have tried I can't get
the Wizard to connect to SQLServer. It tells me it can't find the
server or access denied. I have set SQL Server to mixed authentication
and have tried both domain and SQL login, and have failed both ways.
I don't think I'm doing anything different on this machine, with one
exception. I am using a Firewall (Norton) on the machine that fails.
I tried disabling it, but I still have the problem. I can link to SQL
Tables via ODBC so the server is working. It is only the Wizard that
is having problems (perhaps he was a Hogwarts dropout). Any help
would be appreciated.
Thanks.
Ira SolomonTry forcing a "shared memory" connection by putting "lpc:" before the name.
For example, if the instance name is MyServer\MyInstance, the servername of
lpc:MyServer\MyInstance will force it to connect with shared memory. If
it's a named instance you should also consider that the firewall may be
blocking UDP port 1434 which would mean you have to specify the port in the
connection string for TCP to work:
tcp:MyServer\MyInstance,1111 (if the sql error log shows that sql is
listening on tcp port 1111).
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Cindy:
Thanks.
'lpc:" works like a charm.
I knew about memory sharing but Books Online make no mention of lpc.
I just looked at some other online versions of books and I can't find it
there either.
This is a great help as I really need to use the large screen of the
desktop.
Ira
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!
and the Developers edition of SQLServer 2000 and the Upsizing Wizard
works fine. On the other machine I have the same version of
SQLServer, but Access 2003. No matter what I have tried I can't get
the Wizard to connect to SQLServer. It tells me it can't find the
server or access denied. I have set SQL Server to mixed authentication
and have tried both domain and SQL login, and have failed both ways.
I don't think I'm doing anything different on this machine, with one
exception. I am using a Firewall (Norton) on the machine that fails.
I tried disabling it, but I still have the problem. I can link to SQL
Tables via ODBC so the server is working. It is only the Wizard that
is having problems (perhaps he was a Hogwarts dropout). Any help
would be appreciated.
Thanks.
Ira SolomonTry forcing a "shared memory" connection by putting "lpc:" before the name.
For example, if the instance name is MyServer\MyInstance, the servername of
lpc:MyServer\MyInstance will force it to connect with shared memory. If
it's a named instance you should also consider that the firewall may be
blocking UDP port 1434 which would mean you have to specify the port in the
connection string for TCP to work:
tcp:MyServer\MyInstance,1111 (if the sql error log shows that sql is
listening on tcp port 1111).
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Cindy:
Thanks.
'lpc:" works like a charm.
I knew about memory sharing but Books Online make no mention of lpc.
I just looked at some other online versions of books and I can't find it
there either.
This is a great help as I really need to use the large screen of the
desktop.
Ira
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!
Sunday, February 19, 2012
Cannot connect to SQL Server
Recently had to reload laptop (XP) and can no longer connect to SQL
Server. Nothing has changed on network side of things - only my
laptop. I have made sure I have SQL SP3 and latest MDAC. I can ping
the server's IP without problem. The username and password is correct.
It's hard to say without any information on the error but have you
tried creating an alias for the server using the Client Network
Utility? Can you ping the server name (not IP)? Are you getting login
failures or connectivity errors?
-Sue
On 25 Oct 2004 12:55:40 -0700, dfulton@.ctap.com (dfulton) wrote:
>Recently had to reload laptop (XP) and can no longer connect to SQL
>Server. Nothing has changed on network side of things - only my
>laptop. I have made sure I have SQL SP3 and latest MDAC. I can ping
>the server's IP without problem. The username and password is correct.
Server. Nothing has changed on network side of things - only my
laptop. I have made sure I have SQL SP3 and latest MDAC. I can ping
the server's IP without problem. The username and password is correct.
It's hard to say without any information on the error but have you
tried creating an alias for the server using the Client Network
Utility? Can you ping the server name (not IP)? Are you getting login
failures or connectivity errors?
-Sue
On 25 Oct 2004 12:55:40 -0700, dfulton@.ctap.com (dfulton) wrote:
>Recently had to reload laptop (XP) and can no longer connect to SQL
>Server. Nothing has changed on network side of things - only my
>laptop. I have made sure I have SQL SP3 and latest MDAC. I can ping
>the server's IP without problem. The username and password is correct.
Cannot connect to SQL Server
Recently had to reload laptop (XP) and can no longer connect to SQL
Server. Nothing has changed on network side of things - only my
laptop. I have made sure I have SQL SP3 and latest MDAC. I can ping
the server's IP without problem. The username and password is correct.It's hard to say without any information on the error but have you
tried creating an alias for the server using the Client Network
Utility? Can you ping the server name (not IP)? Are you getting login
failures or connectivity errors?
-Sue
On 25 Oct 2004 12:55:40 -0700, dfulton@.ctap.com (dfulton) wrote:
>Recently had to reload laptop (XP) and can no longer connect to SQL
>Server. Nothing has changed on network side of things - only my
>laptop. I have made sure I have SQL SP3 and latest MDAC. I can ping
>the server's IP without problem. The username and password is correct.
Server. Nothing has changed on network side of things - only my
laptop. I have made sure I have SQL SP3 and latest MDAC. I can ping
the server's IP without problem. The username and password is correct.It's hard to say without any information on the error but have you
tried creating an alias for the server using the Client Network
Utility? Can you ping the server name (not IP)? Are you getting login
failures or connectivity errors?
-Sue
On 25 Oct 2004 12:55:40 -0700, dfulton@.ctap.com (dfulton) wrote:
>Recently had to reload laptop (XP) and can no longer connect to SQL
>Server. Nothing has changed on network side of things - only my
>laptop. I have made sure I have SQL SP3 and latest MDAC. I can ping
>the server's IP without problem. The username and password is correct.
Tuesday, February 14, 2012
Cannot connect to remote Sql Server 2005
Hi;
I installed the dev version of SqlServer 2005 and can access it fine on the
server it is on. And the properties say it allows remote connections.
But SqlServer Management Studio cannot connect from my workstation to the
server. And I cannot connect using ADO.NET or JDBC.
SSMS says "An error...Named Pipes Provider, error: 40 - Could not open a
connection to SQL Server)(Microsoft SQL Server, Error: 233)
The ADO.NET exception is:
System.Data.SqlClient.SqlException was unhandled
Message="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)"
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=20
LineNumber=0
Number=233
Server="lumiere"
State=0
StackTrace:
at
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DBConnTest.SqlServer2005Test.TestSqlServerConnecti on(Boolean
useSSPI) in C:\src\DBConnTest\DBConnTest\SqlServer2005Test.cs: line 31
at DBConnTest.Program.Main() in
C:\src\DBConnTest\DBConnTest\Program.cs:line 29
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context( Object state)
at System.Threading.ExecutionContext.Run(ExecutionCon text
executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Any ideas?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
Hello Dave,
To resolve this issue, please do the following steps on the server:
1. Start SQL Server Configuration Manager in the Start Menu -> Microsoft
SQL Server 2005 -> Configuration Tools
2. Under SQL Server 2005 Network Configuration, Enabled TCP/IP
3. Right clicked Properties on TCP/IP, on the IP Address tab, enabled the
appropriate, active IP Address and then test to connect to the server again.
If this still could not help, please do the following on the client:
1. Start SQL Server Configuration Manager
2. Under SQL Native Client Configuration, Right click Aliases, click New
Alias.
3. Add the Server name and Port No and then test to connect to the server
again.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti.../default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||The TCP/IP (and named pipes) was disabled. Turning that on fixed it.
I understand starting with everything locked down but boy is it a pain...
Any suggestions of a good Sql Server 2005 book for someone who knows Sql
Server 2000?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Wei Lu [MSFT]" wrote:
> Hello Dave,
> To resolve this issue, please do the following steps on the server:
> 1. Start SQL Server Configuration Manager in the Start Menu -> Microsoft
> SQL Server 2005 -> Configuration Tools
> 2. Under SQL Server 2005 Network Configuration, Enabled TCP/IP
> 3. Right clicked Properties on TCP/IP, on the IP Address tab, enabled the
> appropriate, active IP Address and then test to connect to the server again.
> If this still could not help, please do the following on the client:
> 1. Start SQL Server Configuration Manager
> 2. Under SQL Native Client Configuration, Right click Aliases, click New
> Alias.
> 3. Add the Server name and Port No and then test to connect to the server
> again.
> Hope this will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscripti.../default.aspx.
> ==================================================
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
|||Here are a few books to get you started:
Microsoft SQL ServerT 2005: Database Essentials Step by Step
Solid Quality Learning
Microsoft Press
ISBN 0-7356-2207-8 (exp. 9/6/06)
Microsoft SQL ServerT 2005: Applied Techniques Step by Step
Solid Quality Learning
Microsoft Press
ISBN 0-7356-2316-3
Inside Microsoft SQL ServerT 2005: The Storage Engine
Kalen Delaney
Microsoft Press
ISBN 0-7356-2105-5 (exp. 9/27/06)
Administrator's Guide to SQL Server 2005 (Paperback)
Buck Woody
Addison-Wesley
ISBN: 0321397975
Pro SQL Server 2005
Thomas Rizzo, Julian Skinner, Adam Machanic
APress
ISBN: 1590594770
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:43747646-4865-4388-9221-0389550C410B@.microsoft.com...[vbcol=seagreen]
> The TCP/IP (and named pipes) was disabled. Turning that on fixed it.
> I understand starting with everything locked down but boy is it a pain...
> Any suggestions of a good Sql Server 2005 book for someone who knows Sql
> Server 2000?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm
>
>
> "Wei Lu [MSFT]" wrote:
I installed the dev version of SqlServer 2005 and can access it fine on the
server it is on. And the properties say it allows remote connections.
But SqlServer Management Studio cannot connect from my workstation to the
server. And I cannot connect using ADO.NET or JDBC.
SSMS says "An error...Named Pipes Provider, error: 40 - Could not open a
connection to SQL Server)(Microsoft SQL Server, Error: 233)
The ADO.NET exception is:
System.Data.SqlClient.SqlException was unhandled
Message="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)"
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=20
LineNumber=0
Number=233
Server="lumiere"
State=0
StackTrace:
at
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DBConnTest.SqlServer2005Test.TestSqlServerConnecti on(Boolean
useSSPI) in C:\src\DBConnTest\DBConnTest\SqlServer2005Test.cs: line 31
at DBConnTest.Program.Main() in
C:\src\DBConnTest\DBConnTest\Program.cs:line 29
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence
assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context( Object state)
at System.Threading.ExecutionContext.Run(ExecutionCon text
executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Any ideas?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
Hello Dave,
To resolve this issue, please do the following steps on the server:
1. Start SQL Server Configuration Manager in the Start Menu -> Microsoft
SQL Server 2005 -> Configuration Tools
2. Under SQL Server 2005 Network Configuration, Enabled TCP/IP
3. Right clicked Properties on TCP/IP, on the IP Address tab, enabled the
appropriate, active IP Address and then test to connect to the server again.
If this still could not help, please do the following on the client:
1. Start SQL Server Configuration Manager
2. Under SQL Native Client Configuration, Right click Aliases, click New
Alias.
3. Add the Server name and Port No and then test to connect to the server
again.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti.../default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||The TCP/IP (and named pipes) was disabled. Turning that on fixed it.
I understand starting with everything locked down but boy is it a pain...
Any suggestions of a good Sql Server 2005 book for someone who knows Sql
Server 2000?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Wei Lu [MSFT]" wrote:
> Hello Dave,
> To resolve this issue, please do the following steps on the server:
> 1. Start SQL Server Configuration Manager in the Start Menu -> Microsoft
> SQL Server 2005 -> Configuration Tools
> 2. Under SQL Server 2005 Network Configuration, Enabled TCP/IP
> 3. Right clicked Properties on TCP/IP, on the IP Address tab, enabled the
> appropriate, active IP Address and then test to connect to the server again.
> If this still could not help, please do the following on the client:
> 1. Start SQL Server Configuration Manager
> 2. Under SQL Native Client Configuration, Right click Aliases, click New
> Alias.
> 3. Add the Server name and Port No and then test to connect to the server
> again.
> Hope this will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...ult.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscripti.../default.aspx.
> ==================================================
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
|||Here are a few books to get you started:
Microsoft SQL ServerT 2005: Database Essentials Step by Step
Solid Quality Learning
Microsoft Press
ISBN 0-7356-2207-8 (exp. 9/6/06)
Microsoft SQL ServerT 2005: Applied Techniques Step by Step
Solid Quality Learning
Microsoft Press
ISBN 0-7356-2316-3
Inside Microsoft SQL ServerT 2005: The Storage Engine
Kalen Delaney
Microsoft Press
ISBN 0-7356-2105-5 (exp. 9/27/06)
Administrator's Guide to SQL Server 2005 (Paperback)
Buck Woody
Addison-Wesley
ISBN: 0321397975
Pro SQL Server 2005
Thomas Rizzo, Julian Skinner, Adam Machanic
APress
ISBN: 1590594770
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:43747646-4865-4388-9221-0389550C410B@.microsoft.com...[vbcol=seagreen]
> The TCP/IP (and named pipes) was disabled. Turning that on fixed it.
> I understand starting with everything locked down but boy is it a pain...
> Any suggestions of a good Sql Server 2005 book for someone who knows Sql
> Server 2000?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm
>
>
> "Wei Lu [MSFT]" wrote:
Friday, February 10, 2012
Cannot connect SQL Server via Internet from Widows 2003 Server
I have a SQLServer 2000 connection problem from a Windows 2003 and Windows
2000 Servers. But it is no problem from other windows XP PCs. Any idea!!!
The Error Message is :
SQL Server registration failed because of the connection failure displayed
below.
ConnectionOpen (LoadNetlibs())Hi
You probably do not have the correct rules in the firewall, although opening
the ports may not be the best of things to do! Use of a VPN would provide
some protection.
For more about the rules needed see http://support.microsoft.com/kb/287932
John
"BMW" wrote:
> I have a SQLServer 2000 connection problem from a Windows 2003 and Windows
> 2000 Servers. But it is no problem from other windows XP PCs. Any idea!!!
>
> The Error Message is :
> SQL Server registration failed because of the connection failure displayed
> below.
> ConnectionOpen (LoadNetlibs())
>
>
2000 Servers. But it is no problem from other windows XP PCs. Any idea!!!
The Error Message is :
SQL Server registration failed because of the connection failure displayed
below.
ConnectionOpen (LoadNetlibs())Hi
You probably do not have the correct rules in the firewall, although opening
the ports may not be the best of things to do! Use of a VPN would provide
some protection.
For more about the rules needed see http://support.microsoft.com/kb/287932
John
"BMW" wrote:
> I have a SQLServer 2000 connection problem from a Windows 2003 and Windows
> 2000 Servers. But it is no problem from other windows XP PCs. Any idea!!!
>
> The Error Message is :
> SQL Server registration failed because of the connection failure displayed
> below.
> ConnectionOpen (LoadNetlibs())
>
>
Subscribe to:
Posts (Atom)