Link two internal sql-servers

Hi!
I have a network with two sql-servers.
One which we can call LOCAL1 is a sql-server with a non public ip-adress.
Another one which we can call PUBLIC1 which is a sql-server with a
public ip-adress.
I have setup one account on each server for connection to the pubs-database.
I add linked server with sp_addlinkedserver on booth servers and also
adds logins with sp_addlinkedsrvlogin.
Evrything seems fine.
When I login with my account that I just setup on the local server with
QA and the query like this
select * from PUBLIC1.pubs.dbo.authors
everything is fine and it works perfect.
But when I login with my account on the public server with QA and query
like this
select * from LOCAL1.pubs.dbo.authors
I get this response after 21 seconds:
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
I am using booth named pipes and TCP/IP on booth the client and the server.
I have tried to add the local server to the public servers hosts file.
But it didnt help.
Any suggestions?
Thanks!Start here:
Potential causes of the "SQL Server Does Not Exist or Access Denied" error
message
http://support.microsoft.com/defaul...kb;en-us;328306
Firewall in between maybe?
HTH
Dylan
"dotNet" <dotnet@.brimba.nu> wrote in message
news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi!
> I have a network with two sql-servers.
> One which we can call LOCAL1 is a sql-server with a non public ip-adress.
> Another one which we can call PUBLIC1 which is a sql-server with a
> public ip-adress.
> I have setup one account on each server for connection to the
pubs-database.
> I add linked server with sp_addlinkedserver on booth servers and also
> adds logins with sp_addlinkedsrvlogin.
> Evrything seems fine.
> When I login with my account that I just setup on the local server with
> QA and the query like this
> select * from PUBLIC1.pubs.dbo.authors
> everything is fine and it works perfect.
> But when I login with my account on the public server with QA and query
> like this
> select * from LOCAL1.pubs.dbo.authors
> I get this response after 21 seconds:
> Server: Msg 17, Level 16, State 1, Line 1
> SQL Server does not exist or access denied.
> I am using booth named pipes and TCP/IP on booth the client and the
server.
> I have tried to add the local server to the public servers hosts file.
> But it didnt help.
> Any suggestions?
> Thanks!|||Hi!
I have looked there.
I found that I cannot even telnet from the local1 to localhost
telnet localhost 1433
this works perfect on the public server...
I can ping localhost and the local ip as well.
But I can connect with QA to local1 and run queries...
What can this be?
I dont have any firewall on the local1-server.
Thanks
Dylan Kruger[MS] wrote:

> Start here:
> Potential causes of the "SQL Server Does Not Exist or Access Denied" error
> message
> http://support.microsoft.com/defaul...kb;en-us;328306
> Firewall in between maybe?
> HTH
> Dylan
> "dotNet" <dotnet@.brimba.nu> wrote in message
> news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
>
> pubs-database.
>
> server.
>
>
>

Link two internal sql-servers

Hi!
I have a network with two sql-servers.
One which we can call LOCAL1 is a sql-server with a non public ip-adress.
Another one which we can call PUBLIC1 which is a sql-server with a
public ip-adress.
I have setup one account on each server for connection to the pubs-database.
I add linked server with sp_addlinkedserver on booth servers and also
adds logins with sp_addlinkedsrvlogin.
Evrything seems fine.
When I login with my account that I just setup on the local server with
QA and the query like this
select * from PUBLIC1.pubs.dbo.authors
everything is fine and it works perfect.
But when I login with my account on the public server with QA and query
like this
select * from LOCAL1.pubs.dbo.authors
I get this response after 21 seconds:
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
I am using booth named pipes and TCP/IP on booth the client and the server.
I have tried to add the local server to the public servers hosts file.
But it didnt help.
Any suggestions?
Thanks!Start here:
Potential causes of the "SQL Server Does Not Exist or Access Denied" error
message
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306
Firewall in between maybe?
HTH
Dylan
"dotNet" <dotnet@.brimba.nu> wrote in message
news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi!
> I have a network with two sql-servers.
> One which we can call LOCAL1 is a sql-server with a non public ip-adress.
> Another one which we can call PUBLIC1 which is a sql-server with a
> public ip-adress.
> I have setup one account on each server for connection to the
pubs-database.
> I add linked server with sp_addlinkedserver on booth servers and also
> adds logins with sp_addlinkedsrvlogin.
> Evrything seems fine.
> When I login with my account that I just setup on the local server with
> QA and the query like this
> select * from PUBLIC1.pubs.dbo.authors
> everything is fine and it works perfect.
> But when I login with my account on the public server with QA and query
> like this
> select * from LOCAL1.pubs.dbo.authors
> I get this response after 21 seconds:
> Server: Msg 17, Level 16, State 1, Line 1
> SQL Server does not exist or access denied.
> I am using booth named pipes and TCP/IP on booth the client and the
server.
> I have tried to add the local server to the public servers hosts file.
> But it didnt help.
> Any suggestions?
> Thanks!|||Hi!
I have looked there.
I found that I cannot even telnet from the local1 to localhost
telnet localhost 1433
this works perfect on the public server...
I can ping localhost and the local ip as well.
But I can connect with QA to local1 and run queries...
What can this be?
I dont have any firewall on the local1-server.
Thanks
Dylan Kruger[MS] wrote:
> Start here:
> Potential causes of the "SQL Server Does Not Exist or Access Denied" error
> message
> http://support.microsoft.com/default.aspx?scid=kb;en-us;328306
> Firewall in between maybe?
> HTH
> Dylan
> "dotNet" <dotnet@.brimba.nu> wrote in message
> news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
>>Hi!
>>I have a network with two sql-servers.
>>One which we can call LOCAL1 is a sql-server with a non public ip-adress.
>>Another one which we can call PUBLIC1 which is a sql-server with a
>>public ip-adress.
>>I have setup one account on each server for connection to the
> pubs-database.
>>I add linked server with sp_addlinkedserver on booth servers and also
>>adds logins with sp_addlinkedsrvlogin.
>>Evrything seems fine.
>>When I login with my account that I just setup on the local server with
>>QA and the query like this
>>select * from PUBLIC1.pubs.dbo.authors
>>everything is fine and it works perfect.
>>But when I login with my account on the public server with QA and query
>>like this
>>select * from LOCAL1.pubs.dbo.authors
>>I get this response after 21 seconds:
>>Server: Msg 17, Level 16, State 1, Line 1
>>SQL Server does not exist or access denied.
>>I am using booth named pipes and TCP/IP on booth the client and the
> server.
>>I have tried to add the local server to the public servers hosts file.
>>But it didnt help.
>>Any suggestions?
>>Thanks!
>
>

Link two internal sql-servers

Hi!
I have a network with two sql-servers.
One which we can call LOCAL1 is a sql-server with a non public ip-adress.
Another one which we can call PUBLIC1 which is a sql-server with a
public ip-adress.
I have setup one account on each server for connection to the pubs-database.
I add linked server with sp_addlinkedserver on booth servers and also
adds logins with sp_addlinkedsrvlogin.
Evrything seems fine.
When I login with my account that I just setup on the local server with
QA and the query like this
select * from PUBLIC1.pubs.dbo.authors
everything is fine and it works perfect.
But when I login with my account on the public server with QA and query
like this
select * from LOCAL1.pubs.dbo.authors
I get this response after 21 seconds:
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
I am using booth named pipes and TCP/IP on booth the client and the server.
I have tried to add the local server to the public servers hosts file.
But it didnt help.
Any suggestions?
Thanks!
Start here:
Potential causes of the "SQL Server Does Not Exist or Access Denied" error
message
http://support.microsoft.com/default...b;en-us;328306
Firewall in between maybe?
HTH
Dylan
"dotNet" <dotnet@.brimba.nu> wrote in message
news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi!
> I have a network with two sql-servers.
> One which we can call LOCAL1 is a sql-server with a non public ip-adress.
> Another one which we can call PUBLIC1 which is a sql-server with a
> public ip-adress.
> I have setup one account on each server for connection to the
pubs-database.
> I add linked server with sp_addlinkedserver on booth servers and also
> adds logins with sp_addlinkedsrvlogin.
> Evrything seems fine.
> When I login with my account that I just setup on the local server with
> QA and the query like this
> select * from PUBLIC1.pubs.dbo.authors
> everything is fine and it works perfect.
> But when I login with my account on the public server with QA and query
> like this
> select * from LOCAL1.pubs.dbo.authors
> I get this response after 21 seconds:
> Server: Msg 17, Level 16, State 1, Line 1
> SQL Server does not exist or access denied.
> I am using booth named pipes and TCP/IP on booth the client and the
server.
> I have tried to add the local server to the public servers hosts file.
> But it didnt help.
> Any suggestions?
> Thanks!
|||Start here:
Potential causes of the "SQL Server Does Not Exist or Access Denied" error
message
http://support.microsoft.com/default...b;en-us;328306
Firewall in between maybe?
HTH
Dylan
"dotNet" <dotnet@.brimba.nu> wrote in message
news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi!
> I have a network with two sql-servers.
> One which we can call LOCAL1 is a sql-server with a non public ip-adress.
> Another one which we can call PUBLIC1 which is a sql-server with a
> public ip-adress.
> I have setup one account on each server for connection to the
pubs-database.
> I add linked server with sp_addlinkedserver on booth servers and also
> adds logins with sp_addlinkedsrvlogin.
> Evrything seems fine.
> When I login with my account that I just setup on the local server with
> QA and the query like this
> select * from PUBLIC1.pubs.dbo.authors
> everything is fine and it works perfect.
> But when I login with my account on the public server with QA and query
> like this
> select * from LOCAL1.pubs.dbo.authors
> I get this response after 21 seconds:
> Server: Msg 17, Level 16, State 1, Line 1
> SQL Server does not exist or access denied.
> I am using booth named pipes and TCP/IP on booth the client and the
server.
> I have tried to add the local server to the public servers hosts file.
> But it didnt help.
> Any suggestions?
> Thanks!
|||Hi!
I have looked there.
I found that I cannot even telnet from the local1 to localhost
telnet localhost 1433
this works perfect on the public server...
I can ping localhost and the local ip as well.
But I can connect with QA to local1 and run queries...
What can this be?
I dont have any firewall on the local1-server.
Thanks
Dylan Kruger[MS] wrote:

> Start here:
> Potential causes of the "SQL Server Does Not Exist or Access Denied" error
> message
> http://support.microsoft.com/default...b;en-us;328306
> Firewall in between maybe?
> HTH
> Dylan
> "dotNet" <dotnet@.brimba.nu> wrote in message
> news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
>
> pubs-database.
>
> server.
>
>
|||Hi!
I have looked there.
I found that I cannot even telnet from the local1 to localhost
telnet localhost 1433
this works perfect on the public server...
I can ping localhost and the local ip as well.
But I can connect with QA to local1 and run queries...
What can this be?
I dont have any firewall on the local1-server.
Thanks
Dylan Kruger[MS] wrote:

> Start here:
> Potential causes of the "SQL Server Does Not Exist or Access Denied" error
> message
> http://support.microsoft.com/default...b;en-us;328306
> Firewall in between maybe?
> HTH
> Dylan
> "dotNet" <dotnet@.brimba.nu> wrote in message
> news:eqmmDXbXEHA.4032@.TK2MSFTNGP11.phx.gbl...
>
> pubs-database.
>
> server.
>
>

Link Between SQL Server 2000 and MSDE Not working! Please HELP !

Hello. I have a SQL Server 2000 Database set up on our network.
We want to run a process on another machine. This machine has MSDE Installed
on it. I have created a new entry in the Linked Server options of the MSDE
Machine to our SQL Server.
However, on trying to query the SQL Server 2000 tables from the MSDE
Database, I get this error:
Error 7302: Could not create an instance of OLE DB Provider 'SQLOLEDB'
I have checked the MDAC_TYP using the MDAC_TYP Checker, and both the SQL
Server and MSDE Machines have the same version running.
I have pinged the SQL Server from the MSDE Server and they can both see each
other.
Any suggestions you might have would be greatly appreciated!!
Thanking you in advance,
m00nm0nkey!!
In message <29E143E6-25FB-4EFF-88B9-D9EE8E23122C@.microsoft.com>,
m00nm0nkey <m00nm0nkey@.discussions.microsoft.com> writes
>Hello. I have a SQL Server 2000 Database set up on our network.
>We want to run a process on another machine. This machine has MSDE Installed
>on it. I have created a new entry in the Linked Server options of the MSDE
>Machine to our SQL Server.
>However, on trying to query the SQL Server 2000 tables from the MSDE
>Database, I get this error:
>Error 7302: Could not create an instance of OLE DB Provider 'SQLOLEDB'
>I have checked the MDAC_TYP using the MDAC_TYP Checker, and both the SQL
>Server and MSDE Machines have the same version running.
>I have pinged the SQL Server from the MSDE Server and they can both see each
>other.
>Any suggestions you might have would be greatly appreciated!!
>Thanking you in advance,
>
Pinging the servers does not prove anything other than each PC is on the
network. Can you connect to the MSDE Server through Enterprise Manager
(adding it to the default Server Group) on the SQL Server machine.
If yes, it is most likely something wrong in how you have defined the
link or referencing the SQL Server in your queries.
If no, then it would suggest the MSDE Server does not have the Network
Protocols enabled (turned off by default in a normal installation).
Alternatively, you may have a firewall or packet filtering enabled on
the MSDE machine blocking ports 1433 (TCP) and 1434 (UDP).
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com

Limiting size of a table in SQL server

hi,

im doing network monitoring app where basically i run a checks on servers every few minutes and log the data to a table. Naturally the table can get big, quite quickly. What I want is to be able to overwrite the table data at the start of each new day. Alternatively, rollup the data into a daily or weekly packets and then overwrite table data. How do i do this?Using a scheduled job in SQL Server would likely be the easiest. Create the code to do what you want in a stored procedure, and then schedule the stored procedure.

In Enterprise Manager, expand the database till you see Management, expand that and right click on Jobs below it and select New Job to create and schedule the job.

Limiting data access based on login information ?

Here is what I want to do : we have on our network 250 stores. I want them to be able to access their P&L, sales, old invoices,... The trick is that I want each store to access his and only his information, without designing 250 times the same report with the store number as a preset value. Is there a way with SSRS to preset the "@.Store" parameter value based upon the login information ?

For this case I would implement row level security, because even if the parameter would be preset, user could gain access to other reports using the URl parameters. Therefore a implemented row level security, which filters out the appropiate value from the results with passing the Windows credentials would help you much more than that.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thks for your answer Jens. I m still quite a newbie with SQL... What are the basic steps to implement row level security ? Do you have to do it in your DB serving as datasource, or in the DB supporting SSRS ?

|||After understanding the principle of that , it should be easy for you to implement:

http://www.google.de/search?hl=de&q=row+level+security+sql+server&meta=

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de