Connect to remote SQL Server from local Web App

I have a SQL Server 2005 instance which resides on a dedicated server hosted by a third party. I am able to connect to this server through my local SQL Management Studio, however, my local ASP.NET 2.0 web application cannot connect. I get the error below. The connection string I use is formatted as...

Connection String:

Server=thesever;uid=myuserid;pwd=mypassword;database=mydatabase

Error:

Failed to connect to database: 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)

The hosting providr claims that the SQL Server configuration settings are as they should be as fars as TCP/IP and Named Pipes are concerned. Does anyone know what might be going on?

I believe I have found the problem. There was a problem creating the proper conneciton string.sqlsql

Connect to remote MYSQL From the local mssql

Connect to remote MYSQL From the local mssqlOn Fri, 21 Dec 2007 03:51:41 -0800 (PST), zhuxingsheng@.gmail.com
wrote:

By creating a Linked Server? Look it up in Books Online.
-Tom.

Quote:

Originally Posted by

>how ?

|||On 21.12.2007 12:51, zhuxingsheng@.gmail.com wrote:

Quote:

Originally Posted by

how ?

You picked the wrong group.

robert|||On Dec 21, 1:51 pm, zhuxingsh...@.gmail.com wrote:

Quote:

Originally Posted by

how ?

Use Linked Servers!|||On 22.12.2007 18:57, Robert Klemme wrote:

Quote:

Originally Posted by

On 21.12.2007 12:51, zhuxingsheng@.gmail.com wrote:

Quote:

Originally Posted by

>how ?

>
You picked the wrong group.

Sorry, I just recognize I made a complete fool out of myself. Please
just ignore my previous posting. Thank you!

Cheers

robert

Connect to Remote Analysis Server

Hi,

How do I connect to a remote Analysis Server using SQL management studio on my local machine.

Thanks in advance..

Hi,

At the remote computer you want to connect, your nt domain username should be at least in the MSOLAPUser group. And if you want to have server-wide permissions your username should be added to the list displayed in the security tab of the olap server properties screen.

Eralper

http://www.kodyaz.com

|||Hi eralper,

Thanks for the reply. But how can my local SQL management studio detect Analysis Services of Network Servers? As of now, it can only detect Database Engines of other network server..

Thanks again...
|||

What is the name of the physical machine you want to connect to?

Also when it was installed was the instance given a name?

If the instance was not given a name then you can just put the machine name in the server edit control, if it has a name then it should be servername\instancename in the control.

|||

Maybe the Analysis Server is not configured to allow remote connections?

1. On the remote machine, start the SQL Server Surface Area Configuration tool and verify that remote connections are enabled.

2. On the remote machine, verify that the SQL Browser windows service is running.

3. If you have the Windows Firewall enabled on the local machine or remote machine, you will need to make sure you open TCP ports so Analysis Server can accept incoming connections. The port numbers Analysis Server listens to are following:
2383 – port default instance of Analysis Server listens to
2382 – port SQL Browser service listens to for Analysis Services requests.

Note: Named instance of Analysis Services will dynamically pick ports to listen on your machine. The easiest way to discover the TCP port the named instance is listening is to look at the configuration file for SQL Server Browser file. Open file located on the %Program files%\Microsoft SQL Server\90\Shared\ASConfig. Open msmdredir.ini file and look at the < Instances> section in it.
For example you might see following in it;
<Instances>
<Instance>
<Name>Inst1</Name>
<Port>56178</Port>
</Instance>
</Instances>

This means your machinename\Inst1 is listening on the port 56178.

In many situations you would like to ensure your named instance is not picking port by itself but listens on pre-defined port. For that, you can modify the Port – Analysis Server property. Make sure you restart Analysis Server and SQL Server Browser service after changing this property.

Hope this helps,

-- Robert

|||

Hi,

If you open the SQL Server Management Studio, open the Registered Servers screen and select Analysis Services.

If you try to add a new olap server, a list of available servers are listed in the dropdownlist. Or you can use the browse button. But I guess these are not coming from a network search process for available servers.

Sorry, I don't have an answer for that.

But I can suggest a tool which scans for sql servers within an IP range, SQLPing2 by C. Andrews from sqlsecurity.com

Unfortunately this tool does not search for the MS AS instances.

Eralper

http://www.kodyaz.com

connect to local SQL2000 server from IDE

Can I connect to a local SQL2000 server from the IDE. I saw the "SQL Server Instance Name" option and tried to change it to both (local) and SQL2K, but it then tries to connect to ./SQL2K etc and fails.

I can only seem to

(1) connect to a named instance (./namedinstancename), which I do not use.

(2) be able to attach a new mdf, rather than connect to an existing db
I know that the express edition is restricted to local dbs, but is it also restricted to named instances?

ThanksCan you post the steps you used to find this. I can't seem to reproduce the problem.|||If the SQL2k instance is a default instance then you can connect just by using . or (local) or <<machinename>>. There is no need to tell SSMS that it is connecting to a SQL2k instance it will detect automatically.

If the instance is named then you need one of the above and then the instance name.

-Euan

Please reply only to the newsgroup/forum so that others can benefit. When posting,please state the version of SQL Server being used and the error number/exact error message text received, if any.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Can you kindly send the steps to create a db and table in sql2000?

connect to local SQL2000 server from IDE

Can I connect to a local SQL2000 server from the IDE. I saw the "SQL Server Instance Name" option and tried to change it to both (local) and SQL2K, but it then tries to connect to ./SQL2K etc and fails.

I can only seem to

(1) connect to a named instance (./namedinstancename), which I do not use.

(2) be able to attach a new mdf, rather than connect to an existing db
I know that the express edition is restricted to local dbs, but is it also restricted to named instances?

ThanksCan you post the steps you used to find this. I can't seem to reproduce the problem.|||If the SQL2k instance is a default instance then you can connect just by using . or (local) or <<machinename>>. There is no need to tell SSMS that it is connecting to a SQL2k instance it will detect automatically.

If the instance is named then you need one of the above and then the instance name.

-Euan

Please reply only to the newsgroup/forum so that others can benefit. When posting,please state the version of SQL Server being used and the error number/exact error message text received, if any.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Can you kindly send the steps to create a db and table in sql2000?sqlsql

Connect to Local

Hey Guys,

I have a SQL connection string question. In my web.config I don't know what to put for the server. I have SQL Server 2005 installed locally.

<connectionStrings>
<add name="database" providerName="System.Data.SqlClient" connectionString= "server=whatgoeshere?;database=test;uid=sa;pwd=password" />
</connectionStrings>

I'm using VS 2005.

Thanks in advance.

-Marc

Try:
(local)

|||

thanks for the reply.

I'm trying to see if the connection string works using "local" but I'm having trouble with my code.

When I add this line: Dim sqlConn as new SQLconnection the "SQLconnection" errors.

I've tried importing SQL at the top but still doesn't work. Is there some reference I need to add?

Thanks.

|||

C# is case sensitive.

It should be Dim sqlConn as new SqlConnection();

|||

I'm actually using VB.

On this line: Dim SqlConn as New SqlConnection() the "SqlConnection()" has the blue line under it indicating an error.

I'm trying to figure out if I need to Import a namespace or maybe when I installed VS2005 I did something wrong.

Thanks.

|||

Try importing:
System.Data.SQLClient

|||

augustwind thanks for the help... it works. Using local for the db and using the import you suggested.

I have a quick question that you might be able to anwer. It VS 2003 whenever I would create a new proj it would store it in the C:\Inetpub\wwwroot blah blah blah. But when I create a new proj in VS2005 it saves it somewhere else. Do you know why that is?

Thanks again.

|||

Sorry - I know where - but I don't know why - -

connect to different SQL via SP

I have three locations: SQL1, SQL2 and SQL3. SQL1 is a Developers Edition on
my local workstation. SQL2 is out on the internet, remote from SQL3 which is
also out there on the internet. Currently, I have a DTS on SQL1 that copies
data from SQL3 over to SQL2. Problem: I would like to get this on a
schedule. I don't want to schedule it on my SQL1 machine and I'm not allowed
DTS packages on SQL2 and SQL3 because they are on shared plans. That leaves
me with scheduling SPs through the use of ASP pages.
Is it possible to transfer data between SQL2 and SQL3 in an SP?
thanks!shank
Have you looked at linked servers? For more details please refer to the BOL
"shank" <shank@.tampabay.rr.com> wrote in message
news:%230vAUpgIGHA.1124@.TK2MSFTNGP10.phx.gbl...
>I have three locations: SQL1, SQL2 and SQL3. SQL1 is a Developers Edition
>on my local workstation. SQL2 is out on the internet, remote from SQL3
>which is also out there on the internet. Currently, I have a DTS on SQL1
>that copies data from SQL3 over to SQL2. Problem: I would like to get this
>on a schedule. I don't want to schedule it on my SQL1 machine and I'm not
>allowed DTS packages on SQL2 and SQL3 because they are on shared plans.
>That leaves me with scheduling SPs through the use of ASP pages.
> Is it possible to transfer data between SQL2 and SQL3 in an SP?
> thanks!
>|||I have just been advised by our webhost that they do not allow Linked
Servers due to security issues.
Is there another way to connect through an SP?
In short, I need to automate transfer of data from SQL3 to SQL2 without
Linked Servers or DTS packages.
thanks!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uEltjujIGHA.3176@.TK2MSFTNGP12.phx.gbl...
> shank
> Have you looked at linked servers? For more details please refer to the
> BOL
> "shank" <shank@.tampabay.rr.com> wrote in message
> news:%230vAUpgIGHA.1124@.TK2MSFTNGP10.phx.gbl...
>

connect string problem

hello,

i use ms sql server 2005 evaluation version. i just want to get an asp
project to work. not to edit, just to work, on my local machine. for
that i use asp studio 2005. (which processes the asp files). i am
almost done, asp is processed, runs, even server connection is up.

but for hours, i cannot establish a working connection, i cannot login
to the ms sql server from the asp scripts. i try and try, nothing
works. i always get [note: this is my own translation from german, not
the actual english error msg] 'error when logging in user bla. this
user isn't assigned to any trusted sql connection.'

i am absolutely new to ms sql and asp. i myself actually develop in
php/apache/mysql. i don't have time to go deeper - i just want to run
this project, for viewing only. *please can anyone tell me what and
where exactly i have to set in ms sql server management studio 9.0*
?!!!

what i did so far:

- set the auth mode to "sql server and win";
(however the manager is connected through win auth because of that
very error)
- my conn string currently is
PROVIDER=SQLOLEDB;DATA SOURCE=DANIEL; Initial Catalog=dbo; User
ID=bla;Password=fasel; (dbo is the database name, DANIEL is the mssql
server name)
- in managemnet studio, in security>auth (?, anmeldungen), where sa
etc is, i created bla, with password=fasel; and in databases>dbo i
added bla to users (i hope so/it looks like).

i also tried integrated security =true or =sspi, instead of user and
pw, resulting in a different error: like "error while processing a
multistep ole db thing, check out the ole db status values. " i would
really like to do that - if I knew how and where! =)

sorry i dont understand all these options and dont want to - just
desperately wish to get this blo*** =) asp project to work. isnt there
any simple solution? any simple setting to do...??!! thanx such a
lot!!!!!!!

daniel

pps win xp pro sp2...perhaps I could get out if I knew where exactly to find really
exact error log?! =) ole db status and whatever... thanx again!!|||Daniel Loose (no@.reply.de) writes:

Quote:

Originally Posted by

but for hours, i cannot establish a working connection, i cannot login
to the ms sql server from the asp scripts. i try and try, nothing
works. i always get [note: this is my own translation from german, not
the actual english error msg] 'error when logging in user bla. this
user isn't assigned to any trusted sql connection.'
>
i am absolutely new to ms sql and asp. i myself actually develop in
php/apache/mysql. i don't have time to go deeper - i just want to run
this project, for viewing only. *please can anyone tell me what and
where exactly i have to set in ms sql server management studio 9.0*
?!!!
>
what i did so far:
>
- set the auth mode to "sql server and win";
(however the manager is connected through win auth because of that
very error)
- my conn string currently is
PROVIDER=SQLOLEDB;DATA SOURCE=DANIEL; Initial Catalog=dbo; User
ID=bla;Password=fasel; (dbo is the database name, DANIEL is the mssql
server name)
- in managemnet studio, in security>auth (?, anmeldungen), where sa
etc is, i created bla, with password=fasel; and in databases>dbo i
added bla to users (i hope so/it looks like).

In Management Studio, in the Object Explorer, right-click the server
itself, and select Properties. Find Security to the left. On the top
of this page, you have two choices for Server authentication. Select
SQL Server and Windows Authentication mode, the second option. You
need to restart the server for it to take effect.

Once you've done this, use the connect string with User ID and Password.

Windows authentication is usually the recommended means of authentication,
but I believe that for ASP and ASP .Net solutions, SQL authentication
is preferred.

--
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||||
|In Management Studio, in the Object Explorer, right-click the server
|itself, and select Properties. Find Security to the left. On the top
|of this page, you have two choices for Server authentication. Select
|SQL Server and Windows Authentication mode, the second option. You
|need to restart the server for it to take effect.
|
|Once you've done this, use the connect string with User ID and Password.
|

thank you. actually i had already done this. i now also added a login
name u1 with pass p1 to server>security>anmeldung (in english? login?
authent?), and somehow fortunately managed to let u1 appear in
server>dbo>security>users, i.e. below my database. my connstring now
is

PROVIDER=SQLOLEDB;DATA SOURCE=DANIEL;DATABASE=dbo;User
ID=u1;Password=p1

(DANIEL is the mssqlserver name, dbo the database name).

note that from the original project the connstring was

PROVIDER=SQLOLEDB;DATA SOURCE=xyz;UID=xxx;PWD=yyy;DATABASE=zzz

i also tried uid instead of user id and pwd instead of password, which
i assume are just aliases?, that is, i now use the same structure as
in the original project, the objects mentioned in the connstring seem
to exist, the sql auth seems to work since now the server manager
after restart logs in with sql auth, using u/p = u1/p1 -- but, it
still doesnt work. but, the problem appearance slightly differs now:
still, ie takes 5 minutes to "load" the page - but then, no error
message at all appears anymore, nor does the page itself - just a
blank screen. whats up??

i guess, only error logs could still help me out? where to find them?
where to get more details? thanx again!!!!|||Daniel Loose (no@.reply.de) writes:

Quote:

Originally Posted by

i also tried uid instead of user id and pwd instead of password, which
i assume are just aliases?, that is, i now use the same structure as
in the original project, the objects mentioned in the connstring seem
to exist, the sql auth seems to work since now the server manager
after restart logs in with sql auth, using u/p = u1/p1 -- but, it
still doesnt work. but, the problem appearance slightly differs now:
still, ie takes 5 minutes to "load" the page - but then, no error
message at all appears anymore, nor does the page itself - just a
blank screen. whats up??
>
i guess, only error logs could still help me out? where to find them?
where to get more details? thanx again!!!!

If you get blank page in your browser, I would suspect that there is a
problem with the HTML sent to the broweser. For help to debug that part,
you may be better of in an ASP forum.

If it takes five minutes before you get that far, I would guess this is
because it takes five minutes to run the query. You can verify in Mgmt
Studio that you are connected by running sp_who2. You should be able
to identify your process.

As for why it takes five minutes to run the query, that it's impossible
to tell with the meager information given.

--
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|||thanx again!

|If you get blank page in your browser, I would suspect that there is a
|problem with the HTML sent to the broweser. For help to debug that part,
|you may be better of in an ASP forum.

It's rather the five minutes, and *then* blank screen. the asp is
simply the 3 connect lines.

|
|If it takes five minutes before you get that far, I would guess this is
|because it takes five minutes to run the query. You can verify in Mgmt
|Studio that you are connected by running sp_who2.

sorry for my stupid question: *where* to run sp_who2 and how? =)

But apparently a connection is not established.

You should be able
|to identify your process.
|

Please also see my new posting where I just discovered that all user
status sql server auth are disabled, and I dont know why - since for
the server , sql server auth *is* enabled ("sql server auth and win
auth")

thanx again for you efforts!|||Daniel Loose (no@.reply.de) writes:

Quote:

Originally Posted by

It's rather the five minutes, and *then* blank screen. the asp is
simply the 3 connect lines.

Not that I know much ASP, but if all you do is to connect, I would
not expect much output...

In any case, since you have not posted any code, and have given a very
vague description of what you are doing, don't execpt very accurate
guesses.

Quote:

Originally Posted by

sorry for my stupid question: *where* to run sp_who2 and how? =)

From a query window in Management Studio.

--
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

Connect at only One port

When connecting to sql 2000 Enterprise manager opens multiple ports.
For example
Proto Local Address Foreign Address State
TCP 192.168.7.12:1433 192.168.7.12:3275 ESTABLISHED
TCP 192.168.7.12:1433 192.168.7.12:3634 ESTABLISHED
TCP 192.168.7.12:3634 192.168.7.12:1433 ESTABLISHED
How can I force sql to connect only at 1433 or other single port. I facts
is there such posibility?
Hi -
If you analyze the entries in the SQL Server error log file, you can verify
that the instance of SQL Server is listening on the correct IP address and on
the correct port. By default, a default instance of SQL Server listens on the
port 1433. You can also use Server Network Utility to verify the protocol
settings for SQL Server and to change the properties in SQL Server, including
the protocols that can connect to SQL Server and the ports that can be used.
For more information about using Server Network Utility, see the "SQL Server
Network Utility" topic in SQL Server Books Online.
Sometimes, SQL Server 2000 may not bind to port 1433 or any other specified
port. This problem may occur if the port is being used by another application
or if you are trying to connect by using an IP address that is not correct.
Therefore, the TCP/IP connections to SQL Server may not be successful and you
may receive the following error message in the SQL Server error log file:
2001-11-14 15:49:14.12 server SuperSocket Info: Bind failed on TCP port 1433.
Please check the below link :
http://support.microsoft.com/default.aspx?kbid=307197
Let me know if it helps you.
"Radin" wrote:

> When connecting to sql 2000 Enterprise manager opens multiple ports.
> For example
> Proto Local Address Foreign Address State
> TCP 192.168.7.12:1433 192.168.7.12:3275 ESTABLISHED
> TCP 192.168.7.12:1433 192.168.7.12:3634 ESTABLISHED
> TCP 192.168.7.12:3634 192.168.7.12:1433 ESTABLISHED
> How can I force sql to connect only at 1433 or other single port. I facts
> is there such posibility?
>

Connect at only One port

When connecting to sql 2000 Enterprise manager opens multiple ports.
For example
Proto Local Address Foreign Address State
TCP 192.168.7.12:1433 192.168.7.12:3275 ESTABLISHED
TCP 192.168.7.12:1433 192.168.7.12:3634 ESTABLISHED
TCP 192.168.7.12:3634 192.168.7.12:1433 ESTABLISHED
How can I force sql to connect only at 1433 or other single port. I facts
is there such posibility?Hi -
If you analyze the entries in the SQL Server error log file, you can verify
that the instance of SQL Server is listening on the correct IP address and o
n
the correct port. By default, a default instance of SQL Server listens on th
e
port 1433. You can also use Server Network Utility to verify the protocol
settings for SQL Server and to change the properties in SQL Server, includin
g
the protocols that can connect to SQL Server and the ports that can be used.
For more information about using Server Network Utility, see the "SQL Server
Network Utility" topic in SQL Server Books Online.
Sometimes, SQL Server 2000 may not bind to port 1433 or any other specified
port. This problem may occur if the port is being used by another applicatio
n
or if you are trying to connect by using an IP address that is not correct.
Therefore, the TCP/IP connections to SQL Server may not be successful and yo
u
may receive the following error message in the SQL Server error log file:
2001-11-14 15:49:14.12 server SuperSocket Info: Bind failed on TCP port 1433
.
Please check the below link :
http://support.microsoft.com/default.aspx?kbid=307197
Let me know if it helps you.
"Radin" wrote:

> When connecting to sql 2000 Enterprise manager opens multiple ports.
> For example
> Proto Local Address Foreign Address State
> TCP 192.168.7.12:1433 192.168.7.12:3275 ESTABLISHED
> TCP 192.168.7.12:1433 192.168.7.12:3634 ESTABLISHED
> TCP 192.168.7.12:3634 192.168.7.12:1433 ESTABLISHED
> How can I force sql to connect only at 1433 or other single port. I facts
> is there such posibility?
>

Connect Access to SQL Server AND Local ODBC Connection

I have a customer that wants me to create a database and use a back end of
SQL Server (hosted on the Internet for his site). This would normally be
easy to create the front end with an ADP and continue life as normal. But,
in order to connect his accounting program to this program that I am
creating, I also need the ADP/MDB to connect to his local ODBC Link
(Business Vision Connect!) This is the software that is installed on the
local machine to speak to the accounting software. I can get Connect! to
work when it isn't in an ADP. I can get SQL Server to work in an ADP. So,
at this point, I can get one or the other to work...
Does anyone know of a way to get SQL Server to work with an MDB without
asking for the SQLServer Password OR a way to get his Connect (Regular ODBC
System DSN) to work in an ADP? I have also tried creating a file DSN (for
Connect!) which looks like it could work with an ADP, but since the
Connect! is rather old, it doesn't seem to like to be put into a FileDSN.
Any ideas would be great!!!
Thanks,
Shawn
You can connect an mdb to SQL Server by creating linked tables or by
using pass-through queries. You supply the connection string in code.
From the MDB, create a DAO TableDef object for the linked tables, and
QueryDef objects for the pass-through queries (which return read-only
result sets). HTH,
Mary
On Wed, 16 Jun 2004 20:27:05 -0400, "Shawn Oatley"
<notmyemail@.address.com> wrote:

>I have a customer that wants me to create a database and use a back end of
>SQL Server (hosted on the Internet for his site). This would normally be
>easy to create the front end with an ADP and continue life as normal. But,
>in order to connect his accounting program to this program that I am
>creating, I also need the ADP/MDB to connect to his local ODBC Link
>(Business Vision Connect!) This is the software that is installed on the
>local machine to speak to the accounting software. I can get Connect! to
>work when it isn't in an ADP. I can get SQL Server to work in an ADP. So,
>at this point, I can get one or the other to work...
>Does anyone know of a way to get SQL Server to work with an MDB without
>asking for the SQLServer Password OR a way to get his Connect (Regular ODBC
>System DSN) to work in an ADP? I have also tried creating a file DSN (for
>Connect!) which looks like it could work with an ADP, but since the
>Connect! is rather old, it doesn't seem to like to be put into a FileDSN.
>Any ideas would be great!!!
>Thanks,
>Shawn
>
|||Shawn,
Find a way to make the ADP work. Linked tables with mdb are a nightmare. Modifying pass through queries on the fly bloats your database and are much harder to maintain than sprocs. Linked tables create excessive connection/locking which leads to DEADLO
CKS. Linked tables should *not be even considered*when the database is accesses through the internet.
Here is a link to a site with numereous connections string examples. http://www.able-consulting.com/ADO_Conn.htm
"Shawn Oatley" wrote:

> I have a customer that wants me to create a database and use a back end of
> SQL Server (hosted on the Internet for his site). This would normally be
> easy to create the front end with an ADP and continue life as normal. But,
> in order to connect his accounting program to this program that I am
> creating, I also need the ADP/MDB to connect to his local ODBC Link
> (Business Vision Connect!) This is the software that is installed on the
> local machine to speak to the accounting software. I can get Connect! to
> work when it isn't in an ADP. I can get SQL Server to work in an ADP. So,
> at this point, I can get one or the other to work...
> Does anyone know of a way to get SQL Server to work with an MDB without
> asking for the SQLServer Password OR a way to get his Connect (Regular ODBC
> System DSN) to work in an ADP? I have also tried creating a file DSN (for
> Connect!) which looks like it could work with an ADP, but since the
> Connect! is rather old, it doesn't seem to like to be put into a FileDSN.
> Any ideas would be great!!!
> Thanks,
> Shawn
>
>

Connect Access to SQL Server AND Local ODBC Connection

I have a customer that wants me to create a database and use a back end of
SQL Server (hosted on the Internet for his site). This would normally be
easy to create the front end with an ADP and continue life as normal. But,
in order to connect his accounting program to this program that I am
creating, I also need the ADP/MDB to connect to his local ODBC Link
(Business Vision Connect!) This is the software that is installed on the
local machine to speak to the accounting software. I can get Connect! to
work when it isn't in an ADP. I can get SQL Server to work in an ADP. So,
at this point, I can get one or the other to work...
Does anyone know of a way to get SQL Server to work with an MDB without
asking for the SQLServer Password OR a way to get his Connect (Regular ODBC
System DSN) to work in an ADP? I have also tried creating a file DSN (for
Connect!) which looks like it could work with an ADP, but since the
Connect! is rather old, it doesn't seem to like to be put into a FileDSN.
Any ideas would be great!!!
Thanks,
ShawnYou can connect an mdb to SQL Server by creating linked tables or by
using pass-through queries. You supply the connection string in code.
From the MDB, create a DAO TableDef object for the linked tables, and
QueryDef objects for the pass-through queries (which return read-only
result sets). HTH,
Mary
On Wed, 16 Jun 2004 20:27:05 -0400, "Shawn Oatley"
<notmyemail@.address.com> wrote:

>I have a customer that wants me to create a database and use a back end of
>SQL Server (hosted on the Internet for his site). This would normally be
>easy to create the front end with an ADP and continue life as normal. But,
>in order to connect his accounting program to this program that I am
>creating, I also need the ADP/MDB to connect to his local ODBC Link
>(Business Vision Connect!) This is the software that is installed on the
>local machine to speak to the accounting software. I can get Connect! to
>work when it isn't in an ADP. I can get SQL Server to work in an ADP. So,
>at this point, I can get one or the other to work...
>Does anyone know of a way to get SQL Server to work with an MDB without
>asking for the SQLServer Password OR a way to get his Connect (Regular ODBC
>System DSN) to work in an ADP? I have also tried creating a file DSN (for
>Connect!) which looks like it could work with an ADP, but since the
>Connect! is rather old, it doesn't seem to like to be put into a FileDSN.
>Any ideas would be great!!!
>Thanks,
>Shawn
>|||Shawn,
Find a way to make the ADP work. Linked tables with mdb are a nightmare. M
odifying pass through queries on the fly bloats your database and are much h
arder to maintain than sprocs. Linked tables create excessive connection/lo
cking which leads to DEADLO
CKS. Linked tables should *not be even considered*when the database is acce
sses through the internet.
Here is a link to a site with numereous connections string examples. .able-consulting.com/ADO_Conn.htm" target="_blank">http://www
.able-consulting.com/ADO_Conn.htm
"Shawn Oatley" wrote:

> I have a customer that wants me to create a database and use a back end of
> SQL Server (hosted on the Internet for his site). This would normally be
> easy to create the front end with an ADP and continue life as normal. But
,
> in order to connect his accounting program to this program that I am
> creating, I also need the ADP/MDB to connect to his local ODBC Link
> (Business Vision Connect!) This is the software that is installed on the
> local machine to speak to the accounting software. I can get Connect! to
> work when it isn't in an ADP. I can get SQL Server to work in an ADP. So,
> at this point, I can get one or the other to work...
> Does anyone know of a way to get SQL Server to work with an MDB without
> asking for the SQLServer Password OR a way to get his Connect (Regular ODB
C
> System DSN) to work in an ADP? I have also tried creating a file DSN (fo
r
> Connect!) which looks like it could work with an ADP, but since the
> Connect! is rather old, it doesn't seem to like to be put into a FileDSN.
> Any ideas would be great!!!
> Thanks,
> Shawn
>
>

Conflict Resolution: Is defining local subscription enough: How to get log of lost record.

Hello All,
I am very much thankful to you all for providing much needed help, and
once again I am at the group with my query. In my replication
implementation in which I have around 100 subscriber I need to decide
what conflict resolution policy should be employed.
We, in our implementation just want that publisher always wins in case
if there is any conflict. Is it enough to create a local subscription
to acheieve this.
Which will ensure that in case of any conflict with the publisher
publisher always wins the conflict.
Also we want that losing party should get log of inforamtion about the
lost record, is there any way to acheive this?
Can you define what you mean by a local subscription?
The best way to alert the user of conflicts is to use the com object
C:\Program Files\Common Files\Microsoft Shared\Database
Replication\WZCNF.DLL
This will display a list of the conflicts. You will then have to poll for
them and send out alerts.
Subscriptions managed by Windows Synchronization Manager using the
interactive resolved will allow the user to manage the conflict when WSM
runs.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Ruchir" <ruchirdhar@.gmail.com> wrote in message
news:88216eb7.0501172243.6e17e067@.posting.google.c om...
> Hello All,
> I am very much thankful to you all for providing much needed help, and
> once again I am at the group with my query. In my replication
> implementation in which I have around 100 subscriber I need to decide
> what conflict resolution policy should be employed.
> We, in our implementation just want that publisher always wins in case
> if there is any conflict. Is it enough to create a local subscription
> to acheieve this.
> Which will ensure that in case of any conflict with the publisher
> publisher always wins the conflict.
> Also we want that losing party should get log of inforamtion about the
> lost record, is there any way to acheive this?

Conflict Resolution: Is defining local subscription enough: How to get log of lost record.

Publisher always wins is the default, so you don't need
to do anything to achieve this.
To get notification of a conflict, you could create a
polling routine (there's no alert that I know of).
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
hi Paul,
Thanks for you reply, I have few more queries
1. Where is this conflict information specially the losing row information is stored, at the publisher side or at the subscriber side? if losing row information is maintained at the publisher side is there any way so that we can store this information at the publisher side.
2. As you talked about creating a polling routine to get notification of conflict, in my implementation I just want a log file which contain information about the losing row nothing else, will the polling routine you are referring to can do the same and alsoI have not much information about how to write polling routine can you throw some light on it?
regards.
Ruchir.

Quote:

Originally posted by Paul Ibison
Publisher always wins is the default, so you don't need
to do anything to achieve this.
To get notification of a conflict, you could create a
polling routine (there's no alert that I know of).
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

|||Have a look at the tables
conflict_<PublicationName>_<ArticleName>_usertable name
and
MSmerge_delete_conflicts
at the publisher.
The polling routine would be not much more than a job
that runs regularly and does a select from this table,
then sends the results in an email as an attachment. The
origin_datasource column could be used to determine the
correct recipient.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Confirm new password? Please help.

Hi,
All of sudden, all my SQL 2K servers start to ask "Confirm
new password" when I assign a database access permission
to a local user. Even though I type in the correct
password, it still say "The confirmation password is not
correct". Right now I simply cannot assign any database
access to the local users. But the domain trusted users
don't have this problem. Does anyone know what the problem
is?
Thank you in advance for your help.
David...I'm trying to remember back - I had this occur ages ago. Have you either
service packed the server or switched client workstation? I "think" it was
fixed by service packing my client machine (to get it inline with the server
).
Alicia
Http://www.sqlporn.co.uk|||I applied SQL 2K security patch about a month ago, and
brought the builder version to 8.00.818. I just found the
article that addresses this problem.
http://support.microsoft.com/default.aspx?kbid=826161
Thanks for your information.
David.
>--Original Message--
>...I'm trying to remember back - I had this occur ages
ago. Have you either service packed the server or switched
client workstation? I "think" it was fixed by service
packing my client machine (to get it inline with the
server).
>Alicia
>Http://www.sqlporn.co.uk
>.
>|||This was a bug with the security rollup for SQL. You need to install build
819.
826161 FIX: You Are Prompted for Password Confirmation After You Change a
http://support.microsoft.com/?id=826161
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Kevin,
I downloaded and applied the hotfix. The problem is gone.
But when I check the SQL server product version that is
still showing 8.00.818(SP3). Is that right? I thought it
should show the version # 8.00.819(SP3). Is there
something that I didn't do right?
Thank you for your help.
David.
>--Original Message--
>This was a bug with the security rollup for SQL. You
need to install build
>819.
>826161 FIX: You Are Prompted for Password Confirmation
After You Change a
>http://support.microsoft.com/?id=826161
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||to dive in, the hotfix just changes a DLL (can't remember which) and doesn't
affect sqlservr.exe so therefore you still see 818. This is expected
behaviour
regards,
Andy.
"David W." <anonymous@.discussions.microsoft.com> wrote in message
news:17d6101c44992$2faee360$a501280a@.phx
.gbl...[vbcol=seagreen]
> Hi Kevin,
> I downloaded and applied the hotfix. The problem is gone.
> But when I check the SQL server product version that is
> still showing 8.00.818(SP3). Is that right? I thought it
> should show the version # 8.00.819(SP3). Is there
> something that I didn't do right?
> Thank you for your help.
> David.
> need to install build
> After You Change a
> confers no rights.|||Hi David,
Sorry. That is correct. SQL Server .exe is still 818.
01-Jun-2003 01:02 2000.80.818.0 7,544,916 bytes Sqlservr.exe
This is the only component stamped 819.
01-Jun-2003 01:01 2000.80.819.0 492,096 bytes Semobj.dll
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Configuring SQLXML IIS

I have configured a virtual directory with my local SQL
Server and local IIS. I am able to execute my templates
without any problems. Pretty cool stuff!
Now I would like to do the same on our production SQL
Server and web server. The SQL Server and web server are
on two different machines. I have read that it is
possible to do this but I am confused as to which
computer I need to connect to through the IIS Virtual
Directory Management console. I am assuming it is the
web server. I tried both the SQL and web server and got
the same error - "An error occured connecting to
<server>. This server does not exist or is unavailable."
1. Can the web server reside on another machine?
2. Which server needs to be configured?
3. Why would I receive the error that I am getting?
Thank you for any assistance that you can provide.
Jason
Yes, the Web Server can be separate from the SQL Server. It's the Web server
you need to configure with the IIS Virtual Directory Management tool, but it
will need to have SQLXML installed. You'll also need to think carefully
about how you configure authentication in your SQLISAPI Virtual Directory.
As for the error, at face-value it looks like a networking issue - I assume
you've tried the usual troubleshooting approaches (i.e. pinging the server
by name or by IP address)?
Graeme Malcolm
Principal Technologist
Content Master Ltd.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:19bc001c42247$c41fd760$a601280a@.phx.gbl...
> I have configured a virtual directory with my local SQL
> Server and local IIS. I am able to execute my templates
> without any problems. Pretty cool stuff!
> Now I would like to do the same on our production SQL
> Server and web server. The SQL Server and web server are
> on two different machines. I have read that it is
> possible to do this but I am confused as to which
> computer I need to connect to through the IIS Virtual
> Directory Management console. I am assuming it is the
> web server. I tried both the SQL and web server and got
> the same error - "An error occured connecting to
> <server>. This server does not exist or is unavailable."
> 1. Can the web server reside on another machine?
> 2. Which server needs to be configured?
> 3. Why would I receive the error that I am getting?
> Thank you for any assistance that you can provide.
> Jason
>
|||Thanks Graeme, what do you mean about configuring
authentication? Are you referring to a user's ability to
access the templates? That was going to be my next
question!
Say I have these templates in my virtual directory that
can be called via HTTP. Anyone can get at them. Is
there a way to pass user credentials to the template in
order to authenticate the user who is trying to access
the template?
Jason

>--Original Message--
>Yes, the Web Server can be separate from the SQL Server.
It's the Web server
>you need to configure with the IIS Virtual Directory
Management tool, but it
>will need to have SQLXML installed. You'll also need to
think carefully
>about how you configure authentication in your SQLISAPI
Virtual Directory.
>As for the error, at face-value it looks like a
networking issue - I assume
>you've tried the usual troubleshooting approaches (i.e.
pinging the server
>by name or by IP address)?
>--
>Graeme Malcolm
>Principal Technologist
>Content Master Ltd.
>"Jason" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:19bc001c42247$c41fd760$a601280a@.phx.gbl...
templates[vbcol=seagreen]
are[vbcol=seagreen]
unavailable."
>
>.
>
|||There are two things that require authentication here.
1. The virtual directory (and the physical template file). You'll need to
decide if your going to allow anonymous access to the virtual directory, in
which case the IUSR_computername accunt will need NTFS file permissions on
the virtual directory folder and the folder containing the templates (if
different), or whether you'll use Windows authentication (in which case the
user's domain account needs the appropriate NTFS permissions. This is just
like any other IIS Web site, and you can use the standard IIS admin tool to
configure site authentication.
2. SQL Server. You've got 4 choices here: (a) Have IIS connect to SQL Server
on the user's behalf, using Windows authentication (select "Always log on
as" and specify the Windows credentials in the virtual directory properties
Security tab - by default it will use the IUSR_computername account and
allow you to automatically synchronize the password. Alternatively, you can
specify any Windows account that you want to and specify the password), (b)
Have IIS connect to SQL Server on the user's behalf, using SQL Server
authentication (select "Always log on as" and specify the SQL Server login
credentials in the virtual directory properties Security tab - you might
also need to enable SQL Server authentication on the SQL Server since by
default it only uses Windows authentication), (c) Have IIS impersonate the
user's Windows credentials when accessing SQL Server (Select "Use Windows
Integrated Authentication" in the virtual directory properties Security
tab), or (d) Have IIS prompt for the user's SQL Server credentials and pass
them to SQL Server using clear text (Select "Use Basic Authentication (Clear
Text) to SQL Server account" in the virtual directory properties Security
tab).
In more general terms (a) and (b) are a form of the "Trusted Server" model
(in which the Web Server application is trusted to use its own credentials
to access the database on the user's behalf), while (c) and (d) are forms of
the "Impersonation/Delegation" model, in which the Web Server accesses the
database using the user's credentials.
In most cases, I'd tend to recommend (a), because it will allow IIS to use
connection pooling (and therefore make the application more scalable).
However, it does mean that everyone who accesses the database through the
Web site uses the same login to SQL Server. If your application is on an
Intranet and you need to force users to use their own account when accessing
SQl Server, then I'd go for (c), in which case Internet Explorer will
automatically send their domain credentials (assuming they're logged into a
domain) or prompt them for their Windows login. The main thing is that the
credentials are encrypted on the network. If you were to use (d) you'd have
to configure the virtual directory to use SSL in order to pass the login
details securely.
Hope that helps,
Graeme
Graeme Malcolm
Principal Technologist
Content Master Ltd.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:1d43801c422ec$75616580$a101280a@.phx.gbl...[vbcol=seagreen]
> Thanks Graeme, what do you mean about configuring
> authentication? Are you referring to a user's ability to
> access the templates? That was going to be my next
> question!
> Say I have these templates in my virtual directory that
> can be called via HTTP. Anyone can get at them. Is
> there a way to pass user credentials to the template in
> order to authenticate the user who is trying to access
> the template?
> Jason
>
> It's the Web server
> Management tool, but it
> think carefully
> Virtual Directory.
> networking issue - I assume
> pinging the server
> message
> templates
> are
> unavailable."

Configuring SQLMail on Standalone PC

Hi,
I want to try some programs using SQL Mail on my Local/Standalone PC.
I do not have a network connection and only have a dialup connection.
How do I setup/configure SQLMail in SQL2000? When I read about it, it
says that I need to have mailbox/profile setup. But I don't have
Exchange Server too.
Somehow I got hold of Exchange Server 2000 120-Eval edition. But I am
unable to install the same, because it says that it needs Active
Directory to be setup first.
Now my Win2K Server is already installed and I don't have Active
Directory setup. Is it possible to setup Active Directory on a
Local/Standalone PC which doesn't have Network card.
Please let me know if there is any possible way to write and test some
programs on a Standalone Win2K Server with is not connected to any
server. What will be the prerequisites of Standalone PC to use
SQLMail locally for testing purpose.
Thanks,
KamleshCan you use SMTP instead? http://www.aspfaq.com/2403
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Kamlesh" <kamlesh2000@.yahoo.com> wrote in message
news:2644c0f6.0311212150.7bba5122@.posting.google.com...
> Hi,
> I want to try some programs using SQL Mail on my Local/Standalone PC.
> I do not have a network connection and only have a dialup connection.
> How do I setup/configure SQLMail in SQL2000? When I read about it, it
> says that I need to have mailbox/profile setup. But I don't have
> Exchange Server too.
> Somehow I got hold of Exchange Server 2000 120-Eval edition. But I am
> unable to install the same, because it says that it needs Active
> Directory to be setup first.
> Now my Win2K Server is already installed and I don't have Active
> Directory setup. Is it possible to setup Active Directory on a
> Local/Standalone PC which doesn't have Network card.
> Please let me know if there is any possible way to write and test some
> programs on a Standalone Win2K Server with is not connected to any
> server. What will be the prerequisites of Standalone PC to use
> SQLMail locally for testing purpose.
> Thanks,
> Kamlesh

Configuring SQL Mail

Hello,
Please pardon my ignorance. I am doing some testing on my local machine (and
then I need to setup a server). I have a mail profile, but when I try to
configure SQL Mail the profile isn't listed. Should it be? When I setup the
server do I need to have Outlook installed? It will be SQL Server 2000.
Thanks for any help, I really appreciate it.
Thanks,
NickSee http://www.aspfaq.com/2403 for troubleshooting tips for SQL Mail.
My suggestion, as that article should make clear, would be to use
xp_smtp_sendmail. We use it on all of our production servers and banished
SQL Mail ages ago.
A
"Nick" <nickfinity@.nospam.nospam> wrote in message
news:B46FAF5C-2223-47A8-8C32-084DE8827592@.microsoft.com...
> Hello,
> Please pardon my ignorance. I am doing some testing on my local machine
> (and
> then I need to setup a server). I have a mail profile, but when I try to
> configure SQL Mail the profile isn't listed. Should it be? When I setup
> the
> server do I need to have Outlook installed? It will be SQL Server 2000.
> Thanks for any help, I really appreciate it.
> Thanks,
> Nick|||Aaron,
Thanks a lot! I'm giving it a try now. I really appreciate your help.
Thanks,
Nick
"Aaron Bertrand [SQL Server MVP]" wrote:

> See http://www.aspfaq.com/2403 for troubleshooting tips for SQL Mail.
> My suggestion, as that article should make clear, would be to use
> xp_smtp_sendmail. We use it on all of our production servers and banished
> SQL Mail ages ago.
> A
>
> "Nick" <nickfinity@.nospam.nospam> wrote in message
> news:B46FAF5C-2223-47A8-8C32-084DE8827592@.microsoft.com...
>
>|||Hello,
Thanks for update. If anything is unclear, get in touch.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Configuring Roles/Membership SQL to not use DBO?

I have a site with roles/membership working fine on my local machine, but I am having serious trouble deploying it to a shared host. My hosting provides a sql 2000 database, but the user created for it that I use is not dbo. I am errors when I try to access my site such as

Couldnot find storedprocedure'dbo.aspnet_CheckSchemaVersion'

The procedure was created under my user, so it's there, but it's full name ia myusername.aspnet_CheckSchemaVersion

How can I tell the asp.net membership/role provider to use my username instead of dbo when it looks for objects?

Thanks 

Configure your website to use a user with myusername as the default schema for your role/membership. By default the role/membership use a connection string named 'LocalSqlServer', so you can change login information of this connection string. For details, please refer to this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

|||

I had my username configured in the connection string, it was just ignoring it. Well, it was connecting to the SQL server with my username, but was still looking for stored procedures using dbo.

Luckily, the blog you linked to did have the source code for the default MS SQL providers. When I looked at the source code for Microsoft's membership/roles providers I found out why it wasn't working. dbo is hard coded into all the stored procedure calls. Makes it kinda hard to use on shared servers where you aren't the dbo.

Anyway, I downloaded the source code, removed all the dbo. calls, recompiled and set up a custom provider to use my new dbo-free sql providers.

Works like a champ. So, consider this one solved.

|||You mentioned getting the source code for the MS SQL providers. Can you tell me where you got that? I found the Access provider athttp://msdn.microsoft.com/asp.net/beta2/providers/default.aspx from the link above. But I can't seem to find the SQL provider. Any help would be much appreciated. Thanks.|||

asylumn:

I had my username configured in the connection string, it was just ignoring it. Well, it was connecting to the SQL server with my username, but was still looking for stored procedures using dbo.

This may because you have something like 'Integrated Security=SSPI' in the connection string, which force to connect using Windows Authentication so the username would be ignored. Still, I'm glad to hear you've solved this issue

|||

jbutler76:

You mentioned getting the source code for the MS SQL providers. Can you tell me where you got that? I found the Access provider athttp://msdn.microsoft.com/asp.net/beta2/providers/default.aspx from the link above. But I can't seem to find the SQL provider. Any help would be much appreciated. Thanks.

Hi jbutler76, Scott has repied you on his bolg, you may check here to find the SQL Provider Source:

http://weblogs.asp.net/scottgu/archive/2006/04/13/Source-Code-for-the-Built_2D00_in-ASP.NET-2.0-Providers-Now-Available-for-Download.aspx

Configuring Distributor

I keep getting the error message:
An error occurred during decryption.
There is no remote user 'distributor_admin' mapped to local user '(null)'
from the remote server 'repl_distributor'.
Changed database context to 'master'. (Microsoft SQL Server, Error: 15466)
I have tried a local server account (as BOL describes), I have tried using
my own SQL account (that has sa priviliges of course), I have even tried the
domain account that runs SQL Agent service (despite the note right there on
the screen that recommends not to!). I get this error at the end of all the
steps whether I try to create a new publication or if I try to configure the
publisher.
ANY help would be appreciated!!
Is this SQL 2005? And is it part of an upgrade? SQL Server 2000 used a
remote server called repl_distributor which uses the distributor admin
account. In SQL Server 2005 this has been replaced by a linked server. In
some cases I have seen the upgrade of a replication topology with a remote
distributor does not work successfully.
In my cases I had to add the linked server and password manually, IIRC.
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
"mrdj" <mrdj@.discussions.microsoft.com> wrote in message
news:A3B17D13-3D6F-4B84-970A-F8FDDCB16144@.microsoft.com...
>I keep getting the error message:
> An error occurred during decryption.
> There is no remote user 'distributor_admin' mapped to local user '(null)'
> from the remote server 'repl_distributor'.
> Changed database context to 'master'. (Microsoft SQL Server, Error: 15466)
> I have tried a local server account (as BOL describes), I have tried using
> my own SQL account (that has sa priviliges of course), I have even tried
> the
> domain account that runs SQL Agent service (despite the note right there
> on
> the screen that recommends not to!). I get this error at the end of all
> the
> steps whether I try to create a new publication or if I try to configure
> the
> publisher.
> ANY help would be appreciated!!
|||It is a fresh install. Add a linked serer to what? could you send me the
details of adding the linked sever I am completely lost.
"Hilary Cotter" wrote:

> Is this SQL 2005? And is it part of an upgrade? SQL Server 2000 used a
> remote server called repl_distributor which uses the distributor admin
> account. In SQL Server 2005 this has been replaced by a linked server. In
> some cases I have seen the upgrade of a replication topology with a remote
> distributor does not work successfully.
> In my cases I had to add the linked server and password manually, IIRC.
> --
> 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
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:A3B17D13-3D6F-4B84-970A-F8FDDCB16144@.microsoft.com...
>
>
|||Check to ensure there is a linked server called repl_distributor and it uses
the security context of distributor_admin
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
"mrdj" <mrdj@.discussions.microsoft.com> wrote in message
news:D77607EC-1CA2-4D9E-8822-F4DCAA1D4976@.microsoft.com...[vbcol=seagreen]
> It is a fresh install. Add a linked serer to what? could you send me the
> details of adding the linked sever I am completely lost.
> "Hilary Cotter" wrote:
|||I tried adding the linked server and it STILL failed! But I'm making progess
because now I know exactly where the error is occuring, when adding the
linked server:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Funny, I tried looking up this error number when all this first happened
(notice below, the text is a little different from my original error) and I
got nothing in my serarch results from Microsoft. I was able to get this to
work on another server, so at least I know it is some internal setting
specific to this server...Any ideas?
REALLY appreciate your help so far!!
"Hilary Cotter" wrote:

> Check to ensure there is a linked server called repl_distributor and it uses
> the security context of distributor_admin
> --
> 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
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:D77607EC-1CA2-4D9E-8822-F4DCAA1D4976@.microsoft.com...
>
>
|||Hilary,
Should this linked server be created on the distributor, or the subscriber,
or both? I am seeing a similar error when trying to setup replication in my
production environment, although it worked fine in test (currently being
rebuilt, so I have no comparison to use atm). I am thinking this might be a
part of my problem.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uoTqv58THHA.3592@.TK2MSFTNGP03.phx.gbl...
> Check to ensure there is a linked server called repl_distributor and it
uses[vbcol=seagreen]
> the security context of distributor_admin
> --
> 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
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:D77607EC-1CA2-4D9E-8822-F4DCAA1D4976@.microsoft.com...
the[vbcol=seagreen]
In
>