Problems linking Access to SQL replicated tables

Hello!
I was wondering if anyone could help me.
I am running an Access application that uses linked tables to connect to a SQL server.
Ever since I turned on replication on those tables, I cannot add records to the table using regular Access forms (and, for that matter, I cannot do it by just double-clicking on the table from Access and trying to enter records).

Any help will be greatly appreciated!!!!!Have you also refreshed those links i.e.(deleted the links and recreated them in Access) since you "turned on replication on those tables" (or not)?|||Yes, I have deleted the link and recreated it after turning on replication, but I still get the same error every time I add a record.|||You are able to add a row via query analyzer or EM, and the table is not a read only subscribed table you are attempting to add rows to? (just asking the obvious things)
If all that is in order you might check to see if the generated link schemas include columns that the system automatically populates with data. If there are some (replication related columns) or others such as identity, GUID, timestamp, etc. columns (that are automatically populated), try removing them from the Access link schemas (not the base tables) then recreate your link(s) and attempt a test row insert. If that does not work try creating a view (test insertion in QA / EM), then create a linked table to the view and test its behavior.sql

Problems creating mirroring on 2005.

What about the security configuration? Have you granted connect permissions
to the other servers' accounts to the database mirroring endpoints?
You should use
grant connect on endpoint::endpoint_mirroring to [domain\account]
Ben Nevarez, MCDBA, OCP
Database Administrator
"ChrisR" wrote:

> SQL2K5 sp1
> Instance names:
> Development\MySQL2K5
> Development\Subscriber
> Development\Witness
> Im trying to set up mirroring on 3 instances on my desktop and having some
> issues (not ideal I know, but it's what I've got to work with for now). He
re
> is what I've done:
> --Create endpoint on principal instance and set recovery model
> CREATE ENDPOINT endpoint_mirroring
> STATE = STARTED
> AS TCP ( LISTENER_PORT = 5022 )
> FOR DATABASE_MIRRORING (ROLE=PARTNER);
> GO
> ALTER DATABASE AdventureWorks
> SET RECOVERY FULL;
> --Create endpoint on mirror instance
> CREATE ENDPOINT endpoint_mirroring
> STATE = STARTED
> AS TCP ( LISTENER_PORT = 5023 )
> FOR DATABASE_MIRRORING (ROLE=PARTNER);
> GO
> --Create endpoint on witness instance
> CREATE ENDPOINT endpoint_mirroring
> STATE = STARTED
> AS TCP ( LISTENER_PORT = 5024 )
> FOR DATABASE_MIRRORING (ROLE=WITNESS);
> GO
> --Backup principal database
> BACKUP DATABASE AdventureWorks
> TO DISK='C:\MirrorBackup\AWBackup.BAK'
> with init;
> GO
> --Restore mirror database
> RESTORE DATABASE AdventureWorks
> FROM DISK='C:\MirrorBackup\AWBackup.BAK'
> WITH NORECOVERY,
> MOVE 'AdventureWorks_Data' TO 'C:\Program Files\Microsoft SQL
> Server\MSSQL.2\MSSQL\DATA\AdventureWorks_Data.mdf',
> MOVE 'AdventureWorks_Log' TO 'C:\Program Files\Microsoft SQL
> Server\MSSQL.2\MSSQL\DATA\AdventureWorks_Log.ldf';
> GO
> --On the mirror server set the principal server
> ALTER DATABASE AdventureWorks
> SET PARTNER =
> 'TCP://MySQL2K5:5022'
> GO
> --On the principal server set the mirror server
> ALTER DATABASE AdventureWorks
> SET PARTNER = 'TCP://MySQL2K5:5023'
> GO
> That last step blows up with:
> Msg 1418, Level 16, State 1, Line 1
> The server network address "TCP://MYSQL2K5:5023" can not be reached or doe
s
> not exist. Check the network address name and that the ports for the local
> and remote endpoints are operational.
> Any ideas?
> TIA, ChrisR
>
>That didn't fix it. As an FYI all 3 instances are running under the same
domain account.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:D8493E83-C7A3-4A76-9302-7FA2C77EE3EF@.microsoft.com...
> What about the security configuration? Have you granted connect
permissions[vbcol=seagreen]
> to the other servers' accounts to the database mirroring endpoints?
> You should use
> grant connect on endpoint::endpoint_mirroring to [domain\account]
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "ChrisR" wrote:
>
some[vbcol=seagreen]
Here[vbcol=seagreen]
does[vbcol=seagreen]
local[vbcol=seagreen]|||SQL2K5 sp1
Instance names:
Development\MySQL2K5
Development\Subscriber
Development\Witness
Im trying to set up mirroring on 3 instances on my desktop and having some
issues (not ideal I know, but it's what I've got to work with for now). Here
is what I've done:
--Create endpoint on principal instance and set recovery model
CREATE ENDPOINT endpoint_mirroring
STATE = STARTED
AS TCP ( LISTENER_PORT = 5022 )
FOR DATABASE_MIRRORING (ROLE=PARTNER);
GO
ALTER DATABASE AdventureWorks
SET RECOVERY FULL;
--Create endpoint on mirror instance
CREATE ENDPOINT endpoint_mirroring
STATE = STARTED
AS TCP ( LISTENER_PORT = 5023 )
FOR DATABASE_MIRRORING (ROLE=PARTNER);
GO
--Create endpoint on witness instance
CREATE ENDPOINT endpoint_mirroring
STATE = STARTED
AS TCP ( LISTENER_PORT = 5024 )
FOR DATABASE_MIRRORING (ROLE=WITNESS);
GO
--Backup principal database
BACKUP DATABASE AdventureWorks
TO DISK='C:\MirrorBackup\AWBackup.BAK'
with init;
GO
--Restore mirror database
RESTORE DATABASE AdventureWorks
FROM DISK='C:\MirrorBackup\AWBackup.BAK'
WITH NORECOVERY,
MOVE 'AdventureWorks_Data' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.2\MSSQL\DATA\AdventureWorks_Data.mdf',
MOVE 'AdventureWorks_Log' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.2\MSSQL\DATA\AdventureWorks_Log.ldf';
GO
--On the mirror server set the principal server
ALTER DATABASE AdventureWorks
SET PARTNER =
'TCP://MySQL2K5:5022'
GO
--On the principal server set the mirror server
ALTER DATABASE AdventureWorks
SET PARTNER = 'TCP://MySQL2K5:5023'
GO
That last step blows up with:
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://MYSQL2K5:5023" can not be reached or does
not exist. Check the network address name and that the ports for the local
and remote endpoints are operational.
Any ideas?
TIA, ChrisR|||What about the security configuration? Have you granted connect permissions
to the other servers' accounts to the database mirroring endpoints?
You should use
grant connect on endpoint::endpoint_mirroring to [domain\account]
Ben Nevarez, MCDBA, OCP
Database Administrator
"ChrisR" wrote:

> SQL2K5 sp1
> Instance names:
> Development\MySQL2K5
> Development\Subscriber
> Development\Witness
> Im trying to set up mirroring on 3 instances on my desktop and having some
> issues (not ideal I know, but it's what I've got to work with for now). He
re
> is what I've done:
> --Create endpoint on principal instance and set recovery model
> CREATE ENDPOINT endpoint_mirroring
> STATE = STARTED
> AS TCP ( LISTENER_PORT = 5022 )
> FOR DATABASE_MIRRORING (ROLE=PARTNER);
> GO
> ALTER DATABASE AdventureWorks
> SET RECOVERY FULL;
> --Create endpoint on mirror instance
> CREATE ENDPOINT endpoint_mirroring
> STATE = STARTED
> AS TCP ( LISTENER_PORT = 5023 )
> FOR DATABASE_MIRRORING (ROLE=PARTNER);
> GO
> --Create endpoint on witness instance
> CREATE ENDPOINT endpoint_mirroring
> STATE = STARTED
> AS TCP ( LISTENER_PORT = 5024 )
> FOR DATABASE_MIRRORING (ROLE=WITNESS);
> GO
> --Backup principal database
> BACKUP DATABASE AdventureWorks
> TO DISK='C:\MirrorBackup\AWBackup.BAK'
> with init;
> GO
> --Restore mirror database
> RESTORE DATABASE AdventureWorks
> FROM DISK='C:\MirrorBackup\AWBackup.BAK'
> WITH NORECOVERY,
> MOVE 'AdventureWorks_Data' TO 'C:\Program Files\Microsoft SQL
> Server\MSSQL.2\MSSQL\DATA\AdventureWorks_Data.mdf',
> MOVE 'AdventureWorks_Log' TO 'C:\Program Files\Microsoft SQL
> Server\MSSQL.2\MSSQL\DATA\AdventureWorks_Log.ldf';
> GO
> --On the mirror server set the principal server
> ALTER DATABASE AdventureWorks
> SET PARTNER =
> 'TCP://MySQL2K5:5022'
> GO
> --On the principal server set the mirror server
> ALTER DATABASE AdventureWorks
> SET PARTNER = 'TCP://MySQL2K5:5023'
> GO
> That last step blows up with:
> Msg 1418, Level 16, State 1, Line 1
> The server network address "TCP://MYSQL2K5:5023" can not be reached or doe
s
> not exist. Check the network address name and that the ports for the local
> and remote endpoints are operational.
> Any ideas?
> TIA, ChrisR
>
>|||That didn't fix it. As an FYI all 3 instances are running under the same
domain account.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:D8493E83-C7A3-4A76-9302-7FA2C77EE3EF@.microsoft.com...
> What about the security configuration? Have you granted connect
permissions[vbcol=seagreen]
> to the other servers' accounts to the database mirroring endpoints?
> You should use
> grant connect on endpoint::endpoint_mirroring to [domain\account]
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "ChrisR" wrote:
>
some[vbcol=seagreen]
Here[vbcol=seagreen]
does[vbcol=seagreen]
local[vbcol=seagreen]|||Let us try something else then.
Is MYSQL2K5 the name of your computer?
BOL recommends to use the fully qualified domain name. Try ipconfig /all and
look for host name and primary dns suffix.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ChrisR" wrote:

> That didn't fix it. As an FYI all 3 instances are running under the same
> domain account.
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:D8493E83-C7A3-4A76-9302-7FA2C77EE3EF@.microsoft.com...
> permissions
> some
> Here
> does
> local
>
>|||The box name is Development. The instance name is MySQL2K5. I have tried
development\mysql2k5 and many variations of it and get incorrect syntax
errors. I also tried the FQDN and still got the original error.
Thanks for all the help.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:2F186919-F424-4707-9320-68474A3A59C1@.microsoft.com...
> Let us try something else then.
> Is MYSQL2K5 the name of your computer?
> BOL recommends to use the fully qualified domain name. Try ipconfig /all
and[vbcol=seagreen]
> look for host name and primary dns suffix.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "ChrisR" wrote:
>
having[vbcol=seagreen]
now).[vbcol=seagreen]
or[vbcol=seagreen]|||On
ALTER DATABASE AdventureWorks
you need to specify your host name and domain name NOT the SQL Server
instance name. For example, development.yourdomain.com.
Run ipconfig /all and look into host name and primary dns suffix.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ChrisR" wrote:
[vbcol=seagreen]
> The box name is Development. The instance name is MySQL2K5. I have tried
> development\mysql2k5 and many variations of it and get incorrect syntax
> errors. I also tried the FQDN and still got the original error.
> Thanks for all the help.
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:2F186919-F424-4707-9320-68474A3A59C1@.microsoft.com...
> and
> having
> now).
> or
>
>|||The box name is Development. The instance name is MySQL2K5. I have tried
development\mysql2k5 and many variations of it and get incorrect syntax
errors. I also tried the FQDN and still got the original error.
Thanks for all the help.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:2F186919-F424-4707-9320-68474A3A59C1@.microsoft.com...
> Let us try something else then.
> Is MYSQL2K5 the name of your computer?
> BOL recommends to use the fully qualified domain name. Try ipconfig /all
and[vbcol=seagreen]
> look for host name and primary dns suffix.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "ChrisR" wrote:
>
having[vbcol=seagreen]
now).[vbcol=seagreen]
or[vbcol=seagreen]|||On
ALTER DATABASE AdventureWorks
you need to specify your host name and domain name NOT the SQL Server
instance name. For example, development.yourdomain.com.
Run ipconfig /all and look into host name and primary dns suffix.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ChrisR" wrote:
[vbcol=seagreen]
> The box name is Development. The instance name is MySQL2K5. I have tried
> development\mysql2k5 and many variations of it and get incorrect syntax
> errors. I also tried the FQDN and still got the original error.
> Thanks for all the help.
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:2F186919-F424-4707-9320-68474A3A59C1@.microsoft.com...
> and
> having
> now).
> or
>
>

Problems continued - Cannot establish remote connection to Analysis Services

hello,

i am trying to connect to Analysis services server through another pc but i am unable to do so.

Using the following commands i manage to connect to analysis services server at my pc

Server.srv=new Server ();

srv.Connect('ip address or name');

but not to another pc. Are there any settings under sql server should i change ?

I assume that you are using Analysis Services 2005.

First, make sure that the Analysis Services allows remote connections:

On the machine running analysis services, please perform the following steps:

- All programs\Microsoft SQL Server 2005\Configuration Tools\Sql Server Surface Area Configuration

- Click on the Surface Area Configuration for Services and Connections

- Select Remote Connections under the MSSQLSERVER\Analysis Services node

- Make sure that Local and Remote connections is selected (to allow remote connections)

At this point, the client machine should be able to connect to the remote server. Before everything works, you will need to make sure that the client machine connection code is running under credentials that can access Analysis Services

|||

Well i have already enable remote connections and chech credentials as well

This is the error i am getting :

{"A connection cannot be made. Ensure that the server is running."} System.Exception {Microsoft.AnalysisServices.ConnectionException}

{"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"} System.Exception {System.Net.Sockets.SocketException}

Any help ? thanks.

|||That is unusual. Does PING work for the remote computer? Also, could you please check any firewall settings on the remote computer? Analysis Services (msmdsrv.exe) needs permissions through the firewall|||

PING works fine among the two ps's and analysis services is excepted under firewall .

I am still facing the same problem.

Can you please provide me the exact connection string from a pc1 with ip 10.181.11.1 to a pc2 with ip 10.181.11.2 (asp form in pc1 to analysis server in pc2)?

Maybe i use a wrong connection string

This is the error i am getting :

Unable to read data from the transport connection : an existing connection was forcibly closed by the remote host

Any help?

Thanks

|||

Are you using OLE DB or Adomd.Net?

The Connection String should look like "Data Source=10.181.11.2; Initial Catalog=<Your Database>"

One possible reason for the error is that your current user does not have permissions on the server. Are the computers in the same domain? If not, is Everyone allowed to access a database on the server?

|||

I am using ADOMD connection,,if you have an example connection string it would be helpful to check with the one i use

(i have tried different ways of setting the connection string but still cannot connect ).

As far as user credentials are concerned i have also tried to set them in different ways.

I am not quite sure which user (WinXP user, Database Engine User , IIS user, Analysis Services user) must have access to which place,, i am a bit confused about this.

I appreciate your help. Thank you

|||

To begin, let's make sure the physical connection works correctly. On the Analysis Services machine, create a new Analysis Services role which has permissions on your target database, and make sure that Everyone is a member of that role.

Then, try to connect from your client machine, using a connection string like

"Data Source=<IP of the remote machine>; Initial catalog=<name of the DB which is accessible to Everyone>"

If this works, the physical connection is OK and we'll focus on credentials.

Are your machines part of the same Windows NT domain? Tell me a few things about your application, I understand it is a web application, is it correct? Is it impersonating the remote user or running uner a set of specified credentials, or running under the default credentials (machine\ASPNET user)?

And, if you don't mind, could you please reply to this thread rather than creating a new post? It is easier to keep track of the issues

|||

We did what you suggested but we still get the same error.

Do we need to give the permissions and to the actual database (database engine) except to the one in analysis services ?

Our machines are part of the same workgroup connected via a router.

It is a web application and it is runnig under the default credentials.

But we tried with a windows application to check if we can connect to the analysis services and we still get the error

We can access a remote database engine througn sql server management studio but not remote analysis services server.

Is there a way to access a remote analysis services through sql server management studio?

Thanks

|||

This reply involves another error (not the one mentioned above). It seems to have a problem in creating the DIMENSION through source code and the problem seems to be on 'Process' command. We removed the Process command from the code and tried to process it through anaysis services management studio and still got error 'process failed' . This is a critical issue ,,i cannot continue to create cubes, etc.

As far as my application is concerned ,,it is a web application ,,the user will choose through an asp form measures and dimensions and then dimensions,cubes,structures will be created dynamically. So the problem is at initial state since i cannot create the dimenions.

Pls help.

This is the source code i use for dimension creation :

static void CreateDateDimension(Database db)

{

// Create the Date dimension

Dimension dim = db.Dimensions.Add("Invitquest");

dim.Type = DimensionType.Time;

dim.UnknownMember = UnknownMemberBehavior.Hidden;

dim.AttributeAllMemberName = "All Periods";

dim.Source = new DataSourceViewBinding(datasourceName);

dim.StorageMode = DimensionStorageMode.Molap;

#region Create attributes

DimensionAttribute attr;

attr = dim.Attributes.Add("Invitquest");

attr.Usage = AttributeUsage.Key;

attr.Type = AttributeType.Date;

attr.OrderBy = OrderBy.Key;

attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "invno"));

// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "tableid");

attr = dim.Attributes.Add("YPopto");

attr.Type = AttributeType.Regular;

attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "Ypopto"));

// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "Ypopto");

attr = dim.Attributes.Add("cancer");

attr.Type = AttributeType.Regular;

attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "CANCER"));

// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "CANCER");

attr = dim.Attributes.Add("AM BIO");

attr.Type = AttributeType.Regular;

attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "Invitquest", "AMBIO"));

// attr.NameColumn = CreateDataItem(db.DataSourceViews[0], "Invitquest", "AMBIO");

#endregion

dim.Update();

}

Thanks.

|||I merged all these threads.|||

> Our machines are part of the same workgroup connected via a router.

This seems to be the issue. Analysis Services uses exclusively Windows Integrated security. User accounts are not shared across machines in a workgroup, only in a domain (or related domains). This might explain both the management studio failure as well as the custom application failure.

Can you try allowing Everyone access to the Analysis Services database? Eventually , the permissions for the Everyone role can be restricted to what is needed (most likely, Read Definition and predictions), but you can start with Everyone as administrator -- not a great security suggestion, but it allows you to easily figure out if this is the source of the problem.

sql

problems connection to Informix database

Hi,

I have a MS SQL 7 running on one machine and want to connect to a Informix database on another machine.

But I always get the error
Server: Msg 7319, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'ind_new_id' with incorrect bookmark ordinal 0.

I have installed the newest version of "Microsoft Data Access Components" and I have the latest Informix odbc driver

When I try to test the connection in the ODBC Data Source Administrator the test returns fine.

Anyone knows what my problem might be?One of the post in this forum refers
The problem is caused because most providers including SQL Server OLE DB provider do
not support index seek.

The 'index as access path' should not be checked when creating a linked server using
the SQL OLEDB. There is a provider level option which is read by the SQL Server from
the following registry.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Providers\SQLOLEDB\IndexAs
Accesspath. Please check whether the value of the above registry key is 0. If it
isn't , please change it to 0 and try the remote query again.

If it doesn't work, I suggest you rebuild a linked server using the SQL OLEDB without
checking 'index as access path'.

Problems connecting with VS.NET Server Explorer

I have SQL Server SPK3 and Visual Studio.NET running on the same machine.
When I try to connect to my SQL Server from the VS.NET Server Explorer I can
expand the server and look at the SQL Server instance on my computer but when
I try to expand the instance, I get a login dialog entitled "SQL Server
Login" which asks for Login and Password. When I put in what I think the
Login and Password should be, it tells me, "The specified procedure could not
be found". If I check the option that says, "Use Windows NT Integrated
Security" it tells me "The specified procedure could not be found". I need
some assistance from some gurus. What's going on here?!!
I cannot help you but have a similar problem. I can add servers, but never
connect and see details. Worse yet, I cannot create a connection. I go
through the dialog and click test connection and get connection "test
connection succeeded" message. When I try to finish the task I get a message
twice saying "Unable to connect to database. The connection failed. Check
your username and password, and try again." Using either Enterprise Manager
or Query Analyzer, I can connect to the server and databases and see whatever
I need to.
I have Visual Studio 2003, I am trying to connect to both a MSDE SP3 (same
machine) and SQL Enterprise SP3 (different machine).
I am not sure when exactly this occurred as in the past I had created some
connections. I noticed it within the last couple weeks as I have gotten back
into .Net for my current project. I cannot use the old connections and once
deleted cannot recreate them as above.
"DBase_Tron" wrote:

> I have SQL Server SPK3 and Visual Studio.NET running on the same machine.
> When I try to connect to my SQL Server from the VS.NET Server Explorer I can
> expand the server and look at the SQL Server instance on my computer but when
> I try to expand the instance, I get a login dialog entitled "SQL Server
> Login" which asks for Login and Password. When I put in what I think the
> Login and Password should be, it tells me, "The specified procedure could not
> be found". If I check the option that says, "Use Windows NT Integrated
> Security" it tells me "The specified procedure could not be found". I need
> some assistance from some gurus. What's going on here?!!
|||

Quote:

Originally posted by DBase_Tron
I have SQL Server SPK3 and Visual Studio.NET running on the same machine.
When I try to connect to my SQL Server from the VS.NET Server Explorer I can
expand the server and look at the SQL Server instance on my computer but when
I try to expand the instance, I get a login dialog entitled "SQL Server
Login" which asks for Login and Password. When I put in what I think the
Login and Password should be, it tells me, "The specified procedure could not
be found". If I check the option that says, "Use Windows NT Integrated
Security" it tells me "The specified procedure could not be found". I need
some assistance from some gurus. What's going on here?!!

|||I have been searching news groups and Microsoft support sites for two days now and finally found a solution to our problem. You should download MDAC 2.8 and install. Apparently a new procedure has been included in this release. Good Luck.|||I had the same problem and what did to solve it was removing the Alias in
the SQL Server Client Network Utility, done.
Hope it helps
Javier.
"Matt Wyncoop" <Matt Wyncoop@.discussions.microsoft.com> wrote in message
news:E55058DA-AA95-48BA-930C-0726BDCAEA28@.microsoft.com...[vbcol=seagreen]
>I cannot help you but have a similar problem. I can add servers, but never
> connect and see details. Worse yet, I cannot create a connection. I go
> through the dialog and click test connection and get connection "test
> connection succeeded" message. When I try to finish the task I get a
> message
> twice saying "Unable to connect to database. The connection failed. Check
> your username and password, and try again." Using either Enterprise
> Manager
> or Query Analyzer, I can connect to the server and databases and see
> whatever
> I need to.
> I have Visual Studio 2003, I am trying to connect to both a MSDE SP3 (same
> machine) and SQL Enterprise SP3 (different machine).
> I am not sure when exactly this occurred as in the past I had created some
> connections. I noticed it within the last couple weeks as I have gotten
> back
> into .Net for my current project. I cannot use the old connections and
> once
> deleted cannot recreate them as above.
>
> "DBase_Tron" wrote:
|||I looked there and I have no aliases.
"Javier Troconis" wrote:

> I had the same problem and what did to solve it was removing the Alias in
> the SQL Server Client Network Utility, done.
> Hope it helps
> Javier.
> "Matt Wyncoop" <Matt Wyncoop@.discussions.microsoft.com> wrote in message
> news:E55058DA-AA95-48BA-930C-0726BDCAEA28@.microsoft.com...
>
>

problems connecting to sql express 2005 server, where mdf file go?

Hello, I have correctly installed sql express 2005 onto my company server. I can connect to the sql express 2005 fine within sql management studio express. I can also connect to it the within visual studio 2005 server explorer. I have my database (MDF) on our server. I am trying to run my application within my client computer. I have changed the connection string property to connect to the server:

"Data Source=CTS\SQLEXPRESS;Initial Catalog=UpdateAttributes;Integrated Security=True"

My program will only work if there is a local copy of MDF database located within my application directory. If I remove the local copy, it errors "No process is on the other end of the pipe" Is it possible to have my application without the local copy of the MDF? I thought the idea is to have the MDF on the server. Then my app would not have the MDF copy!?Fixed the problem. Went to the server, changed the sql server 2005 surface area configuration under remote connections from using TCP/IP to TCP/IP and named pipes.

Problems connecting to server using Management Studio

Hi all,
I got this problem which makes me struggle in the last few days.
I am able to connect to my local server using a query analyzer or calling sql commands in a window application, but there's no way I can access it in Management Studio: by clicking "Connect" it just waits forever, and it doesn't respond to any other command (it must be shut by terminating the process)
Got any hints?

Thanks

Mauro

Try restarting the sql services may be your server is in hunged state......but i am not sure if that would solve the problem

|||Unfortunately, it doesn't do the trick... in fact, it's like Manag. Studio is able to connect to the server (I can see the list of databases in advanced options) but it doesn't show the result afterwards. Could it be a security/account problem?

Thanks

M|||Hi again,
just another hint trying to understand what's going on.
I just spent a couple of hours removing both the server and the client components and install it again, but the problems remains. Does configuration survive removal? Or should I look somewhere else?

Thanks

Mauro
|||From Management Studio are u trying to connect using Windows authentication or SQL authentication?
|||Both actually. And the result is the same connecting to a local or remote machine, that's why I am quite curious about this error (that in fact makes development harder... )

Mauro

Problems connecting to server using Management Studio

Hi all,
I got this problem which makes me struggle in the last few days.
I am able to connect to my local server using a query analyzer or calling sql commands in a window application, but there's no way I can access it in Management Studio: by clicking "Connect" it just waits forever, and it doesn't respond to any other command (it must be shut by terminating the process)
Got any hints?

Thanks

Mauro

Try restarting the sql services may be your server is in hunged state......but i am not sure if that would solve the problem

|||Unfortunately, it doesn't do the trick... in fact, it's like Manag. Studio is able to connect to the server (I can see the list of databases in advanced options) but it doesn't show the result afterwards. Could it be a security/account problem?

Thanks

M|||Hi again,
just another hint trying to understand what's going on.
I just spent a couple of hours removing both the server and the client components and install it again, but the problems remains. Does configuration survive removal? Or should I look somewhere else?

Thanks

Mauro
|||From Management Studio are u trying to connect using Windows authentication or SQL authentication?
|||Both actually. And the result is the same connecting to a local or remote machine, that's why I am quite curious about this error (that in fact makes development harder... )

Mauro

problems connecting to remote SQL Server 2005

I'm using Visual Studio 2005 Pro and am attempting to connect to a remote SQL Server 2005. I have the server name, SQL login credentials, and database name. However, when I try connecting I get this error:

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

I know that remote access is enabled because I received the connection instructions directly from the database administrator. I've tried turning off my firewall. I've tried connecting with Data source: Microsoft SQL Server using both Data providers: ".NET Framework Data Provider for SQL Server" and ".NET Framework Data Provider for OLE DB". Nothing seems to work.

Any suggestions for what I may be doing wrong? Do I have to have certain software installed on my computer to make this work (other that VS2005)?

-Mathminded

You have to configure SQL Server for remote connection and it is covered in the thread below, post again if you still need help. Hope this helps.

http://forums.asp.net/thread/1379211.aspx

|||

Thanks, Caddre. Just to clarify, I am trying to connect to a remote SQL Server 2005 that is maintained by someone else. They already have remote access enabled, but I haven't been able to connect to it. They have hundreds of users and the rest of them are connecting fine. Do I also have to enable remote access on my local SQL Express installation in order to connect to their server? It seems counterintuitive to me so I want to double-check before I spend several MORE hours trying to get this to work.

Thanks!

|||

I see your point but there are many reason for such problem so it takes time, I have found two troubleshooting links provided by Microsoft and another provided by another developer, run through the check list and post again if none works. Hope this helps.

http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

http://blogs.msdn.com/sql_protocols/archive/2006/04/21/581035.aspx

http://geekswithblogs.net/timh/archive/2006/01/30/67586.aspx

|||

Thanks again, Caddre. I really appreciate your help. I've checked out all that information but it hasn't led me to a solution. I hate to give up an entire night of work, but I'm going to have to give up on this for now and try again tomorrow. If I come up with anything, I'll post it.

Thanks! :-)

|||If those did not work then it is either connection string or permissions you need to check back with them I hope you are not having this problem with Godaddy because users always run into problem with them. Hope this helps.|||

Problem solved! :-) It turns out they had never had a remote user have to access the SQL server from outside the company, so it was a firewall issue. They added my IP as an exception and it worked flawlessly. Thanks again, Caddre, for your willingness to help. I really appreciate it.

-Mathminded

|||

Problem solved! :-) It turns out they had never had a remote user have to access the SQL server from outside the company, so it was a firewall issue. They added my IP as an exception and it worked flawlessly. Thanks again, Caddre, for your willingness to help. I really appreciate it.

-Mathminded

|||

I am glad to see your problem was resolved but fire wall addressed in the protocol troubleshooting link I gave you.

http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

|||

You're right, it was in those lists. That was one of the things I tried checking last night and one of the reasons I decided to give up. Unfortunately, there is no way (that I know of) to know with certainty that you are being blocked by a firewall. Last night I did try to ping and telnet to the server (two things from the links you provided) but when that didn't work it either meant they had disabled those functions OR I was being blocked by a firewall.

I'm glad you replied. I had marked the thread as resolved but hadn't remembered to mark your post as the answer. I don't know how the whole points thing works on this site, but if that's how people get points I wanted to make sure you got them.

Thanks again for all your help.

-Mathminded

|||Fire wall always block database and web server, it is the second thing to check after the configuration of the server and the points are not important to me anymore I have moved on from that subject, I always post again as needed so it will help future users with same problem.sql

Problems connecting to MSDE through ADO.NET

Hi there,
i've installed MSDE and have successfully connected to it from a remote version of Enterprise Manager but when i try to connect using ADO.NET from a website using the same login details i get the following message:
"SQL Server does not exist or access denied"
I installed msde with DISABLENETWORKPROTOCOLS=0 and SECURITYMODE=SQL so everything should be setup properly.
My connection string looks like this:
server=ip_address\instance_name;uid=myusername;pwd=mypassword;database=mydatabase
This connection string works fine when testing locally (without ip address ie. localhost\instance_name)
Any ideas why this doesn't work??You need to check that if the user has accessto the database. For most hosting companies they provide ASPNET useraccount and also NETWORK users. Give permission to ASPNET user and seeif it works also try the same for NETWORK users.

|||Thanks for the reply, you've lost me a bit though. I've setup my own server using Apache and mod_aspdotnet and have successfully tested it remotely from asp.net pages connecting to a MySQL database also on my server. Now i wish to use MSDE and am getting this problem.
How do i setup an ASPNET user account and give it permission to use the database? And why do i need to?
cheers

Problems connecting to MSDE on Windows 2003

I have installed MSDE 2000 SP3a on Windows 2003 Server Web edition.
I am trying to connect to this DB using enterprise manager from another
machine (Windows 2000 Server where SQL Server is installed) with no luck. I
am getting: SQL Server does not exist or access is denied. ConnectionOpen
(Connect())".
I have tried connecting using both Windows Authentication mode and using the
sa account (which I am not sure I know the password for the MSDE).
Can anyone help ?
Thanks
ra294@.hotmail.comCheck whether the instance is listening on any network protocols using
Server Network utility and enable them appropriately.
Thanks,
Bala.
This posting is provided "AS IS" with no warranties, and confers no
rights.
"ra294" <ra294@.hotmail.com> wrote in message
news:%23qkr5RW%23DHA.3808@.TK2MSFTNGP09.phx.gbl...
> I have installed MSDE 2000 SP3a on Windows 2003 Server Web edition.
> I am trying to connect to this DB using enterprise manager from another
> machine (Windows 2000 Server where SQL Server is installed) with no luck.
I
> am getting: SQL Server does not exist or access is denied. ConnectionOpen
> (Connect())".
> I have tried connecting using both Windows Authentication mode and using
the
> sa account (which I am not sure I know the password for the MSDE).
> Can anyone help ?
> Thanks
> ra294@.hotmail.com
>

Problems Connecting to Database

I am having a hard time getting my registration form to connect to my database via a stored procedure. Any help would be appreciated. The code is listed below

protectedvoid submit_Click(object sender,EventArgs e)

{

SqlConnection connection =

newSqlConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);

SqlCommand command =

newSqlCommand("GE_sp_INSERT_USER", connection);

command.Parameters.Add("@.FirstName",SqlDbType.NVarChar).Value = txtFirstName.Text;

command.Parameters.Add("@.LastName",SqlDbType.NVarChar).Value = txtLastName.Text;

command.Parameters.Add("@.UserName",SqlDbType.NVarChar).Value = txtUserName.Text;

command.Parameters.Add("@.Password",SqlDbType.NVarChar).Value = txtPassword.Text;

command.Parameters.Add("@.PhoneNumber",SqlDbType.NVarChar).Value = txtPhoneNumber.Text;

command.Parameters.Add("@.EmailAddress",SqlDbType.NVarChar).Value = txtEmailAddress.Text;

command.Parameters.Add("@.Address",SqlDbType.NVarChar).Value = txtAddress.Text;

command.Parameters.Add("@.City",SqlDbType.NVarChar).Value = txtCity.Text;

command.Parameters.Add("@.State",SqlDbType.NVarChar).Value = txtState.Text;command.Parameters.Add("@.ZipCode",SqlDbType.NVarChar).Value = txtZipCode.Text;

connection.Open();

command.ExecuteNonQuery();

connection.Dispose();

}

ALTER PROCEDUREdbo.GE_sp_INSERT_USER

(

@.FirstNamenvarchar(50),

@.LastNamenvarchar(50),

@.UserNamenvarchar(50),

@.Passwordnvarchar(50),

@.PhoneNumbernvarchar(50),

@.EmailAddressnvarchar(50),

@.Addressnvarchar(50),

@.Citynvarchar(50),

@.Statenvarchar(50),@.ZipCodenvarchar(50)

)

AS

INSERT INTOUSERS

(FirstName, LastName, UserName, Password, PhoneNumber, EmailAddress, Address, City, State, ZipCode)

VALUES

(@.FirstName, @.LastName, @.UserName, @.Password, @.PhoneNumber, @.EmailAddress, @.Address, @.City, @.State, @.ZipCode)

RETURN

You say you are having a hard time "connecting" to your database. What exactly is the problem you're having? Are you getting an error?

|||

You need to set the CommandType:

command.CommandType =CommandType.StoredProcedure;

|||

I have added the code below to my code - I placed it right below my sqlCommand. - it still does not work. the error says it cannot find the stored procedure. The webconfig looks correct.

SqlCommand command =newSqlCommand("GE_sp_INSERT_USER", connection);

command.CommandType =CommandType.StoredProcedure;

thanks for your help|||

That error message has meaning.

Try this:

SqlCommand command =newSqlCommand("dbo.GE_sp_INSERT_USER", connection);

|||

That did not work either. Below is my webconfig - I may be missing something easy.

<connectionStrings>

<addname="myConnectionString"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\gevjen.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient"/>

</connectionStrings>

thanks again for sticking with this to help me out...

|||

A few things

1) Is this connection string working somewhere else in your application?

2) If you connect to your db manually and execute the command do you get any result?

|||

hey i am too getting a hard time in making connection to sqlserver,like i have made a connection object and its working but when i reach the open function nothing works,i had been working over this since last 4 days!please guide me how to do it!

|||The database works elsewhere and the stored procedure works as well. I am missing something easy I believe within the connection or webconfig.|||

gevjen:

The database works elsewhere and the stored procedure works as well. I am missing something easy I believe within the connection or webconfig.

Could you copy and paste the actual error message, and the show the line that causes it?

|||

kamna:

hey i am too getting a hard time in making connection to sqlserver...

This should help you:http://www.mikesdotnetting.com/Article.aspx?ArticleID=69

sql

Problems connecting thru firewall

I have developed an application that handles data from a SQL server runnig inside my main domain.

When i connect with the SQL server from the inside i have no problems at all.

However we opened up the application (smart client application) for some beta testers and i bumped into some problems. i changed the connectionstring to use the IP for the server. I also tried a registered dns name, but i got the following

The aspnetdb i use for authentication is refusing to run the stored procedures and i get the famous disconnected due to the remote server does not accept remote calls, or something like that.

If i disable the Authentication in the application and just run the application with the same connectionstring IP or DNS, parts of the application works. Some of the stored procedures get executed , and the others does not get executed.

I have looked at the owner of the items but they all have the same owner and exec rights. I have checked my C# code and they are all using the patterns to execute the calls the same way.

Does anyone have any idea whats going on here ?

I also confirmed that the correct SQL ports has been opened in the PIX.
I ran home and tried to connect the sql server managment studio from home and i got access , the application still behaves like before

how about using a sql server mixed mode for authentication.|||

Hi

The SQL server is set to mixed mode security and i'm using a SQL login i created with dbo schema.

|||

is the server configured to accept local and remote connection

in the surface configuration

start>programs> sqlserver2005>

configuration tools>surface area configuration>

configuration for service and connection>datbase engine

>remote connection> check local and remote connection

|||

Thanks for your answer

I found the problem last night. In the solution someone had added a SQL report that had a hardcoded connectionstring. The try catch found the connection issue and then skipped parts of the load of the application.

Once i removed the conn string everything is working fine...

Problems Connect a Network Drive with SQL Server Agent

Hello
I have MS SQL 7.00.1094 on NT 4.0
When I connect a Network Drive (net use.../User:local User
on Remote System) with SQL Server Agent I cannot access
this.
If I take the same command on the desktop (Command Shell)
the access is o.K.
The SQL Server Agent is started with the same Account as I
logged on locally.
Even I connect a network drive z.B. U: local, I can not
access this from SQL Server Agent though is the same
global user.
But this Problem exist only 7 days ago.
Thanks
MartinDid someone add a proxy account to the SQL agent? Go to Enterprise Manger
and check the properties for SQL server agent | Job System tab. You should
verify then that you can map the drive with the proxy account.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Martin" <anonymous@.discussions.microsoft.com> wrote in message
news:106b801c3f46d$5ee8bef0$a301280a@.phx
.gbl...
> Hello
> I have MS SQL 7.00.1094 on NT 4.0
> When I connect a Network Drive (net use.../User:local User
> on Remote System) with SQL Server Agent I cannot access
> this.
> If I take the same command on the desktop (Command Shell)
> the access is o.K.
> The SQL Server Agent is started with the same Account as I
> logged on locally.
> Even I connect a network drive z.B. U: local, I can not
> access this from SQL Server Agent though is the same
> global user.
> But this Problem exist only 7 days ago.
> Thanks
> Martin|||A service, such as SQL Server Agent, is not supposed to be able to see
mapped drives. You should use a URL from a service.
180362 INFO: Services and Redirected Drives
http://support.microsoft.com/?id=180362
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Problems after reinstall SQL 2000

I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
connect to server.
It´s installed on Windows 2000 Server SP4.
Thanks a lot.What errors? Check your SQL Server error logs and the Windows Event viewer
(sys and app logs)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"jomagogre" <jomagogre@.discussions.microsoft.com> wrote in message
news:4FBDB47F-441E-4D9A-A736-1E4ADD64B445@.microsoft.com...
>I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It´s installed on Windows 2000 Server SP4.
> Thanks a lot.|||Please try "SQLSERVERAGENT service" start with "Local System Account"
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It´s installed on Windows 2000 Server SP4.
> Thanks a lot.|||I can see the following error in event viewer, trying to connect to sever
throught Enterprise Manager:
ID: 17055
Description:
17310:
process_login: el proceso 2276 gerenero una execption grave C0000005
EXCEPTIO_ACCESS_VIOLATION. Sql Server termina este proceso
When try to start SQLSERVERAGENT it´s register a menssage in event viewer
with ID: 103 telling that is imposible to start the service because the
server could not be contacted.
"jomagogre" wrote:
> I had to uninstall SQL 2000 to remove SP4, now after reinstall SQL,
> SQLSERVERAGENT is unable to start and opening Enterprise Manager cannot
> connect to server.
> It´s installed on Windows 2000 Server SP4.
> Thanks a lot.

Problems acessing the database after creating a website on localhost

I cannot access the data source when I create a website in express - when I try to connect to the database I get an error telling that I am unable to connect to the data source - I tried doing it through the Visual Studio and through the Web Configaration.

Can some please help - I need to conncet!!!

What the connction string and the exact error message ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

"Failed to generate a user instance of SQL Server due to failure in starting the process for the user instance. The connection will be closed"

This is the error messgae that I get when I try to connect to the data source.

Can you help?

|||Do you have SQL Server Express installed ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Reese C. M. Harris wrote:

"Failed to generate a user instance of SQL Server due to failure in starting the process for the user instance. The connection will be closed"

This is the error messgae that I get when I try to connect to the data source.

Can you help?

This is a known issue and the solution is the one posted by user Reen in the long thread below. Hope this helps.

http://forums.microsoft.com/msdn/showpost.aspx?postid=293667&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0

Problem:fail to invoke remote RPC method

I have two xp sp2 machines(one desktop with sql server running, the other is
a virtual pc, on the same domain), I'm trying to connect between the two
using the dtcping.exe tool from ms
the virtual pc has vs2005 etc installed and I can't get it to run a
distributed transaction on the sql server machine, both machines have the sp2
firewall disabled.
the rpc services are running, msdtc service are running,
on the virtual pc I get the following
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:09:03.756-->Start DTC connection test
Name Resolution:
Gilbert-->10.0.4.22-->Gilbert
08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
Problem:fail to invoke remote RPC method
Error(0x6BA) at dtcping.cpp @.289
-->RPC pinging exception
-->1722(The RPC server is unavailable.)
RPC test failed
on the desktop sql server machine I get this
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:08:50.353-->Start DTC connection test
Name Resolution:
Perth-->10.0.4.23-->Perth
08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
Problem:fail to invoke remote RPC method
Error(0x5) at dtcping.cpp @.289
-->RPC pinging exception
-->5(Access is denied.)
RPC test failed
the msdtc service has been set to use my domain account and all the options
have been enabled, network access, inbound, outbound etc.
I have set up the msdtc to use ports 5000-5015
any ideas out there?
to get this poc working
Try turning off Norton internet worm protection...
Stuart
"SP" wrote:

> I have two xp sp2 machines(one desktop with sql server running, the other is
> a virtual pc, on the same domain), I'm trying to connect between the two
> using the dtcping.exe tool from ms
> the virtual pc has vs2005 etc installed and I can't get it to run a
> distributed transaction on the sql server machine, both machines have the sp2
> firewall disabled.
> the rpc services are running, msdtc service are running,
> on the virtual pc I get the following
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:09:03.756-->Start DTC connection test
> Name Resolution:
> Gilbert-->10.0.4.22-->Gilbert
> 08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
> Problem:fail to invoke remote RPC method
> Error(0x6BA) at dtcping.cpp @.289
> -->RPC pinging exception
> -->1722(The RPC server is unavailable.)
> RPC test failed
> on the desktop sql server machine I get this
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:08:50.353-->Start DTC connection test
> Name Resolution:
> Perth-->10.0.4.23-->Perth
> 08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
> Problem:fail to invoke remote RPC method
> Error(0x5) at dtcping.cpp @.289
> -->RPC pinging exception
> -->5(Access is denied.)
> RPC test failed
> the msdtc service has been set to use my domain account and all the options
> have been enabled, network access, inbound, outbound etc.
> I have set up the msdtc to use ports 5000-5015
> any ideas out there?
> to get this poc working
>
|||Thanks Stuart, you are the man!
"Stuart" wrote:
[vbcol=seagreen]
> Try turning off Norton internet worm protection...
> Stuart
> "SP" wrote:

Problem:fail to invoke remote RPC method

I have two xp sp2 machines(one desktop with sql server running, the other is
a virtual pc, on the same domain), I'm trying to connect between the two
using the dtcping.exe tool from ms
the virtual pc has vs2005 etc installed and I can't get it to run a
distributed transaction on the sql server machine, both machines have the sp
2
firewall disabled.
the rpc services are running, msdtc service are running,
on the virtual pc I get the following
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:09:03.756-->Start DTC connection test
Name Resolution:
Gilbert-->10.0.4.22-->Gilbert
08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
Problem:fail to invoke remote RPC method
Error(0x6BA) at dtcping.cpp @.289
-->RPC pinging exception
-->1722(The RPC server is unavailable.)
RPC test failed
on the desktop sql server machine I get this
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:08:50.353-->Start DTC connection test
Name Resolution:
Perth-->10.0.4.23-->Perth
08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
Problem:fail to invoke remote RPC method
Error(0x5) at dtcping.cpp @.289
-->RPC pinging exception
-->5(Access is denied.)
RPC test failed
the msdtc service has been set to use my domain account and all the options
have been enabled, network access, inbound, outbound etc.
I have set up the msdtc to use ports 5000-5015
any ideas out there?
to get this poc working Try turning off Norton internet worm protection...
Stuart
"SP" wrote:

> I have two xp sp2 machines(one desktop with sql server running, the other
is
> a virtual pc, on the same domain), I'm trying to connect between the two
> using the dtcping.exe tool from ms
> the virtual pc has vs2005 etc installed and I can't get it to run a
> distributed transaction on the sql server machine, both machines have the
sp2
> firewall disabled.
> the rpc services are running, msdtc service are running,
> on the virtual pc I get the following
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:09:03.756-->Start DTC connection test
> Name Resolution:
> Gilbert-->10.0.4.22-->Gilbert
> 08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
> Problem:fail to invoke remote RPC method
> Error(0x6BA) at dtcping.cpp @.289
> -->RPC pinging exception
> -->1722(The RPC server is unavailable.)
> RPC test failed
> on the desktop sql server machine I get this
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:08:50.353-->Start DTC connection test
> Name Resolution:
> Perth-->10.0.4.23-->Perth
> 08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
> Problem:fail to invoke remote RPC method
> Error(0x5) at dtcping.cpp @.289
> -->RPC pinging exception
> -->5(Access is denied.)
> RPC test failed
> the msdtc service has been set to use my domain account and all the option
s
> have been enabled, network access, inbound, outbound etc.
> I have set up the msdtc to use ports 5000-5015
> any ideas out there?
> to get this poc working
>|||Thanks Stuart, you are the man!
"Stuart" wrote:
[vbcol=seagreen]
> Try turning off Norton internet worm protection...
> Stuart
> "SP" wrote:
>

problem: user account access (always uses the same account)

I've configured the IIS with only windows authentication, when i connect to
Reporting Server or Reporting Administrator uses the windows account, but
the security rules work different:
I have configured rules for two accounts: my windows account and
IUSR_machine.
When i try to connect to servers i put my windows account and goes ok, but
the security rules works with the rules assigned to the iusr_machine. Any
rule assigned to my user doesn't have effect, and all the changes makes in
the IUSR_machine's rules have effect.
I've configured restrict access to the iusr_machine and grant permission for
my windows account. When i connect with my windows account and i try to do
any task that iusr_machine haven't permission, the server response me that
the iusr_machine haven't permmission to do it.
Any idea?
thank you.
Oliver
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> Usually this is because anonymous is set on the IIS web site settings.
>
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "oli" <oli1350@.hotmail.com> wrote in message
> news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> > I'm having problem with the authentication in reports. When a user
sign
> > in to Report Administrator or Report Server validates with the IIS'
> > configuration. Onces inside always use the same user with the rules
> > security: IWAM_machine.
> > I need the account used inside of Reporting Server/Reporting
> > Administration
> > should be the same that the account used to validates with IIS.
> >
> > It's possible'
> >
> > Thank you in advanced.
> >
> > Oliver
> >
> >
>
>You have to disable anonymous access for both Reports and Reportserver
virtual directories.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"oli" <oli1350@.hotmail.com> wrote in message
news:#YUfIwBaEHA.212@.TK2MSFTNGP12.phx.gbl...
> I've configured the IIS with only windows authentication, when i connect
to
> Reporting Server or Reporting Administrator uses the windows account, but
> the security rules work different:
> I have configured rules for two accounts: my windows account and
> IUSR_machine.
> When i try to connect to servers i put my windows account and goes ok, but
> the security rules works with the rules assigned to the iusr_machine. Any
> rule assigned to my user doesn't have effect, and all the changes makes in
> the IUSR_machine's rules have effect.
> I've configured restrict access to the iusr_machine and grant permission
for
> my windows account. When i connect with my windows account and i try to do
> any task that iusr_machine haven't permission, the server response me
that
> the iusr_machine haven't permmission to do it.
> Any idea?
> thank you.
> Oliver
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
> mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> > Usually this is because anonymous is set on the IIS web site settings.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "oli" <oli1350@.hotmail.com> wrote in message
> > news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > > I'm having problem with the authentication in reports. When a user
> sign
> > > in to Report Administrator or Report Server validates with the IIS'
> > > configuration. Onces inside always use the same user with the rules
> > > security: IWAM_machine.
> > > I need the account used inside of Reporting Server/Reporting
> > > Administration
> > > should be the same that the account used to validates with IIS.
> > >
> > > It's possible'
> > >
> > > Thank you in advanced.
> > >
> > > Oliver
> > >
> > >
> >
> >
>|||I uses the windows integrated authentication in both, but with the same
result: the rules works like if i authenticates with iwam_machine.
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> escribió en el mensaje
news:utWbctEaEHA.2792@.TK2MSFTNGP09.phx.gbl...
> You have to disable anonymous access for both Reports and Reportserver
> virtual directories.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "oli" <oli1350@.hotmail.com> wrote in message
> news:#YUfIwBaEHA.212@.TK2MSFTNGP12.phx.gbl...
> > I've configured the IIS with only windows authentication, when i connect
> to
> > Reporting Server or Reporting Administrator uses the windows account,
but
> > the security rules work different:
> > I have configured rules for two accounts: my windows account and
> > IUSR_machine.
> >
> > When i try to connect to servers i put my windows account and goes ok,
but
> > the security rules works with the rules assigned to the iusr_machine.
Any
> > rule assigned to my user doesn't have effect, and all the changes makes
in
> > the IUSR_machine's rules have effect.
> >
> > I've configured restrict access to the iusr_machine and grant permission
> for
> > my windows account. When i connect with my windows account and i try to
do
> > any task that iusr_machine haven't permission, the server response me
> that
> > the iusr_machine haven't permmission to do it.
> >
> > Any idea?
> >
> > thank you.
> >
> > Oliver
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
> > mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > Usually this is because anonymous is set on the IIS web site settings.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "oli" <oli1350@.hotmail.com> wrote in message
> > > news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > > > Hi,
> > > > I'm having problem with the authentication in reports. When a
user
> > sign
> > > > in to Report Administrator or Report Server validates with the IIS'
> > > > configuration. Onces inside always use the same user with the rules
> > > > security: IWAM_machine.
> > > > I need the account used inside of Reporting Server/Reporting
> > > > Administration
> > > > should be the same that the account used to validates with IIS.
> > > >
> > > > It's possible'
> > > >
> > > > Thank you in advanced.
> > > >
> > > > Oliver
> > > >
> > > >
> > >
> > >
> >
> >
>|||sorry,
i wanted to say i uses only windows integrated authentication in both(not
uses anonymous access)
"oli" <oli1350@.hotmail.com> escribió en el mensaje
news:ub%23HEVLaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> I uses the windows integrated authentication in both, but with the same
> result: the rules works like if i authenticates with iwam_machine.
>
> "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> escribió en el mensaje
> news:utWbctEaEHA.2792@.TK2MSFTNGP09.phx.gbl...
> > You have to disable anonymous access for both Reports and Reportserver
> > virtual directories.
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "oli" <oli1350@.hotmail.com> wrote in message
> > news:#YUfIwBaEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > I've configured the IIS with only windows authentication, when i
connect
> > to
> > > Reporting Server or Reporting Administrator uses the windows account,
> but
> > > the security rules work different:
> > > I have configured rules for two accounts: my windows account and
> > > IUSR_machine.
> > >
> > > When i try to connect to servers i put my windows account and goes ok,
> but
> > > the security rules works with the rules assigned to the iusr_machine.
> Any
> > > rule assigned to my user doesn't have effect, and all the changes
makes
> in
> > > the IUSR_machine's rules have effect.
> > >
> > > I've configured restrict access to the iusr_machine and grant
permission
> > for
> > > my windows account. When i connect with my windows account and i try
to
> do
> > > any task that iusr_machine haven't permission, the server response me
> > that
> > > the iusr_machine haven't permmission to do it.
> > >
> > > Any idea?
> > >
> > > thank you.
> > >
> > > Oliver
> > >
> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> escribió en el
> > > mensaje news:OT0ifxqZEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > > Usually this is because anonymous is set on the IIS web site
settings.
> > > >
> > > > --
> > > > Brian Welcker
> > > > Group Program Manager
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > > "oli" <oli1350@.hotmail.com> wrote in message
> > > > news:eHPoJtZZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> > > > > Hi,
> > > > > I'm having problem with the authentication in reports. When a
> user
> > > sign
> > > > > in to Report Administrator or Report Server validates with the
IIS'
> > > > > configuration. Onces inside always use the same user with the
rules
> > > > > security: IWAM_machine.
> > > > > I need the account used inside of Reporting Server/Reporting
> > > > > Administration
> > > > > should be the same that the account used to validates with IIS.
> > > > >
> > > > > It's possible'
> > > > >
> > > > > Thank you in advanced.
> > > > >
> > > > > Oliver
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>