SQL Database In My Application With Windows Authentication Rejects Accessing After Deploying And Remote Access

Dec 13, 2007

SQL Database in my application with windows authentication rejects accessing after deploying and remote access

1- My web applications databese access is windows authentication

2- In developing area there is no problem for accessing database

3- After deploying to another server there is problem accessing database:
Cannot open user default database. Login failed.
Login failed for user 'BRCK231ASPNET'.

 How can I solve this problem?

Thanks.

View 1 Replies


ADVERTISEMENT

Remote Access Using Windows Authentication

May 22, 2015

After 2 days of reading everything on the net about setting up Remote Access of my SQL 2012 Express using Windows Authentication I'm still not able to connect from a remote client onto my SQL Server Database Engine. I can get connected if using SQL Server Authentication. I have set all the parameters to allow access (read and tried everything from this site: URL.... but when I try using SSMS from the remote client to login I get Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452).I've disable the firewall (Even though I have put in rules to allow port 1433 and UDP port 1434). Nothing is allowing me to connect. I've have tried every solution listed and got nowhere. My network is very simple with only three computers connected via a Linksys router (Two running Windows 7 the test client is running Windows 8.1). I can shared files and folders between all. Each computer only has one user defined (default admin user).

I need to make this work as I have to document it for other end users who will be using an application I created that requires an SQL Database and it needs to be accessible by other users on their network.

View 2 Replies View Related

Deploying Windows Based Database Application

May 10, 2007



Hi,

I am developing a application which is dependent on Sql database (mdf).

I want to know how should i need to deploye or Package the database along with my

application , would i need to instal the sql server exp on to the client system, or there

is any other way to do it , I know that an Access file can be accessed through the

application even the client system dont hav Office, Is there any such type of

mechanism , through which we can do the same with sql database



View 2 Replies View Related

Remote Access For Windows Form Application

Jan 10, 2007

I have a windows based software application that connects remotely to a sql server 2005 and calls stored procedures. There is someone that I work with that is cautioning the company strongly that this is a bad thing to do in terms of security. Isn't this a very common thing to do? Assuming that the SQL Server installation is setup appropriately. Is this a bad practice?

View 4 Replies View Related

MSDTC - Remote Accessing SQL Server 2005 From A Desktop Application - Windows 2003 Server

Dec 6, 2007

Hi,

I am developing a windows application that needs to communicate with a remote SQL server 2005 database. Server allows remote connections and MSDTC service also running. Do I need to run MSDTC service on the client machine where I use desktop application ? any ideas ? It's throwing some error like
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.

But my SQL Server allows remote connection, and I am able to do a select statement.
But when I insert/update anything, it's throwing this error. I guess some problem with MSDCT. Anybody have any idea ?

View 1 Replies View Related

Creating A Database Based Webservice And Accessing It Through Windows Application

Jun 11, 2008

Geekz,
My problem is that , I had setup blog on server say, blog.xyz.com [I am using blogengine.net, which is in ASP.Net]. It is using sql server2005 as a backend for storing its blog's posts. After settingup blog, i tried  to access its database through my windows application. But while development I was getting error that
"An error has occured while establishing a onnection to the server. When connecting to SQL server 2005, this failure may be caused by the fact that under the defaukt settings SQL server doesnot allow remote connections.(Provider Named Pipes, error :40 - Could not open a connection to SQL Server)"
 I am using  [String ConnectionString = "Data Source=sql-v123.mesa11.1Server.net; Initial Catalog=abc; User ID=xyz; Password=xyz123";]
Then I decided to created a webservice that will access the data from databse blog and store it somewhere in datatable  and using windows application i will retrieve those data for end user. So I want to to know that whether i can access the datatable of webservice holding the blog data from windows application or not. if answer is Yes, then please provide me with source or some great links. Or if There is any other option so that I can access my database directly from windows application, then it would be better. Looking for your answers.
 Thanks and regards

View 3 Replies View Related

Authentication An Application Using Windows Integrated Authentication

May 12, 2006

Hi all,

My work is using a shared application
which accesses a MSSQL 2000 database. To access the application, the
folder on the Windows 2003 Server is shared and users can access the
folder through a shared drive.


For the application to access the
database, it uses an ODBC connection to the MSSQL server which
originally used the SA password.


We have recently switched to using
Windows Integrated Authentication because we believe it offers a
higher level of security. However the only way in which we have been
able to enable this is to add the windows users to the SQL server.


The problem with this is that the
application sets permissions for individual users on what records
they can see within the database. We have found that by adding the
windows users to the SQL Server, they can bypass the permissions the
set by the application by simply using any application that can use
an ODBC connection, such as Enterprise Manager, and see all the
database.

One way around this would be to set up
domains of users with access privileges to the tables which reflect
the permissions set by the application, and configuring a view of the
data so they may only see the records that they have permissions to.
However to do this would require a high administrative cost to ensure
that changes made in the application are reflected in the privileges
of the SQL server.

Instead, is there a way the SQL server
can authenticate that the ODBC connection is coming from the correct
application using Windows Integrated Authentication?

This would allow the applcation to
determine security, and stop users from connecting to the SQL server
using other applications.

Alternatively, can the SQL server,
using Windows Integrated Authentication, also ask the application to
supply a username and password?

Any help with this matter would be
greatly appreciated.

Thanks!

View 4 Replies View Related

Error Provider Cannot Be Found. It May Not Be Properly Installed. After Deploying Application On Windows 2003 Server

May 23, 2007

hello folks

i have recently started to work with the analysis services and i am having some problems.

i have made a web application that for now just tries to connect to an analysis server.

The server is installed on an xp sp 2 system.

for testing, i used my local computer, which is running also win xp sp2. After deploying, the application can connect to the AS server on the other machine. the problem occurs when i try to deploy the applicatuion on the production server, which is running win 2k3 server on 32 bit. When deploying, i use the same connection string, so it should try to connect to the AS server installed on a win xp sp2 system.

The first thing that came to my mind was to check the MDAC versions, be cause of the message: "Provider cannot be found. It may not be properly installed."

on my computer, where the application worked ok, the version is MDAC 2.8 SP 1 Windows XP SP 2

on the win2k3 server, the MDAC version is : MDAC 2.8 SP2.... i thought it was the version of the service pack, so o searched for the update of MDAC 2.8 SP1, trying to install mdac 2.8 sp2 to see if i was to see the same error, but i found that mdac 2.8 sp2 is only for win2k3 server, and for win xp is mdac 2.8 sp1, according to this link: http://support.microsoft.com/default.aspx/kb/884103

Now i got confused and have no clues how to make this work...

Can anybody give any hint?

View 2 Replies View Related

SQL 2012 :: Grant Read-only Access To Windows Logins On Remote Standby Database

Mar 23, 2015

We log ship our production database tansaction logs to a secondary database on a separate remote domain.

Incidentally, this was not set up via the "Ship Transaction Logs" wizard, but instead we had to use the various system stored procedures after restoring a copy of the database on the remote domain in standby mode.

We now have an issue where users are unable to access the remote secondary database without having sysadmin privileges. Clearly we want to avoid this!

We want to be able to use Windows Authentication mode on the server of the secondary database. But since the two domains differ, is it possible to even achieve this?

How can we set up read-only access for users on the secondary database without giving them sysadmin privileges?

View 3 Replies View Related

Why Does Bulk Insert Task Not Work From Remote Servers With Windows Authentication?

Jun 10, 2007

Using Bulk Insert Task extensively in our solution. Everything was working great till we deployed it in stage columns. The database server is different from application servers. We have ASP.NET web services driving SSIS packages on application server. After struggling thru several security issues to get this working (ended up creating an application pool with a domain account) we are now stuck with this problem. On a different note still don't understand what specific security permission is available to domain account that makes it work.

Read in some blog that SQL Server 2005 SP2 Beta had this (Bulk Insert) fixed but not in final production version. Is there a specific reason why this is so?

SSIS and the API is quite easy to work with but associated security and deployment issues are not always clear. A lot of answers seem to be coming from end users - thanks a lot to all for sharing your experiences - sadly not presented clearly in SSIS documentation.

View 2 Replies View Related

Unable To Connect To SQL SERVER 2005 Database Engine Using Windows Authentication Under Windows Vista...

Mar 26, 2008

Hallo there,

I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.

My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.

I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress

But nothing happens!

Please i am very desperate, any information will be gratefully accepted.

This is my installation Information



Code Snippet

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001


Thank you in advance,
Patonios


View 3 Replies View Related

SQL Server 2005 Rejects Remote Internet Connections

Sep 27, 2007

PROBLEM:


SQL 2005 rejects connection from an ASP.net test webpage (shown below).

CONFIGURATION:

Internet > Concast Cable > Router > Sever01 Nic1 > Server01 SBS 2003 & SQL 2005 > Sever01 Nic2 > Switch > Local Area

Linksys Router WRV54G( Firmware Version: 2.39.2): Port Range Forwarding TCP 1433 and UDP 1434

Small Business Server 2003 Premium (Server Name: Server01)

Two network cards: Internet Ionnection and Local Area Network
Ran: Configure E-mail And Internet Connection Wizzard
Ran: Remote Access Wizzard (disables access to Windows Firewall)
Note: Remote workplace, Outlook Web Access, Sharepoint, etc, on ports 443,444, 3389, 4125 All work remotely - so Linksys router and RRAS port settings are working.

Routing And Remote Access(RRAS) >NAT/Basic Firewall > Internet Ionnection > Services And Ports

Added TCP Incoming Port 1433, Private Address 127.0.0.1, Outgoing Port 1433
Added UDP Incoming Port 1434, Private Address 127.0.0.1, Outgoing Port 1434

SQL Server 2005 Standard Edition version 9.0.3042 (installed on same machine, default instance ID MSSQLSERVER)

By default: TCP protocol is enabled and local remote connections are enabled on standard Edition. Also by default: MSSQLSERVER automatic/started/running and SQL Server Browser automatic/started/running

Ran: SQL Server 2005 Surface Area Configuration to confirm MSSQLSERVER instance settings are running.
Using: SQL Server Authentication: Login and Password
"sa" is a default account that works locally.


SQL Server Configuration Manager:

MSSQLSERVER protocols: Share Memory and TCP/IP enabled
TCP port 1433 by default (confirmed listening by ERRORLOG)


Microsoft SQL Server Management Studio

Database Engine lists SERVER01 (instead of SERVER01MSSQLSERVER - the default instance is not named explicitly)

Created database "Test" under SERVER01 > Databases.
Created table "tblCategories" in "Test" (included some fields and data)


Server-Side Successful?


netstat -ano | findstr 1433
TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING 2004

Client-Side

Ping Successful

ping <xxx.xxx.xxx.xxx>
Telnet Successful (blank screen)

telnet <xxx.xxx.xxx.xxx> <port#>


TEST ASP.net Web Page Button Sub

I have this button on a page at Godaddy.com connecting to an instance of MS SQL provided by Godaddy and there is no problem connecting to that SQL Server.

Public Sub TestSQL_Click(Sender As Object, e As EventArgs)

Dim rdr As SqlDataReader = Nothing
Dim conn As SqlConnection = new SqlConnection("Data Source=tcp:xxx.xxx.xxx.xxx; Initial Catalog=Server01 blCategories; User ID=sa; Password=xxx")


conn.Open()

Dim cmd As SqlCommand = new SqlCommand("SELECT Category FROM tblCategories;", conn)
rdr = cmd.ExecuteReader()

rdr.Close()
conn.Close()
End Sub


ERROR:
The follworing error occurs or variations of it depending on different connection string configurations:

Occurs at: conn.Open()

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: TCP Provider, error: 0 - 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.)


THOUGHTS

Possibly a bad connection string or Microsoft security issue.

I've attempted many other connection string formats such as:

Dim conn As SqlConnection = new SqlConnection("Data Source=xxx.xxx.xxx.xxx,1433;
Network Library=DBMSSOCN; Initial Catalog=Server01Test; User ID=sa; Password=xxx")


But I continue to receive connection failure messages (or invalid connection string errors for incorrectly formed connection strings).

I've tried disabling RRAS and Windows Firewall and the same errors resulted.

Any feedback would be appreciated.

View 29 Replies View Related

How To Use Windows Authentication To Access SQL Server

Sep 30, 2005

hello ,I have a problem with connecting to SQL Server by Windows Authentication.It's the error:"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. "and this is a source code :"SqlConnection cn = new SqlConnection ("Data Source=PLGRZFLS0001;Initial Catalog=Magazyn;Integrated Security=SSPI;Trusted_Connection=Yes");cn.Open();SqlCommand cmd = new SqlCommand("exec proc_permission",cn); SqlDataReader dr= cmd.ExecuteReader() ;dr.Read(); "in my web.config :<authentication mode="Windows" /> <identity impersonate="true"/>i have no idea what is wrong :(:( bye,sorry for my english

View 2 Replies View Related

Unauthorised Access Via Windows Authentication

Mar 13, 2008



Hi Guys,

My boss is concern that when using Windows authentication, a user can access any database that they have the rights too, using any SQL tool, and make unauthorised changes. He thinks that using SQL authentication is better because the username/password can be hidden from the user. (Access to the database is controlled by our applicatoin.)

Could someone knowledgeable in this are please comment.

Many thanks

Ray

View 1 Replies View Related

Using C# To Access SQL Server At Another PC With Windows Authentication

Oct 8, 2007

Brief Description: I would like to use C# to write a program to access a SQL Server instance which is at another PC and using Windows Authentication. (I know how to use SQL Server Authentication, but I need to use Windows Authentication only.)

Detailed Description:
1. I have two PCs, and I would like to write a C# program in PC1. to access SQL Server at PC2 with Windows Authentication only.

2. I installed Microsoft Dynamics POS system. I install the POS Database with Windows Authentication only at PC2, but then I can install POS at my PC1, and when I set up the connection to the SQL Server, POS will pop up a dialog to ask me the username and password. I can just use the PC2's windows user account to login. Then POS can work fine. I would like to do the same just like what they did.

3. I tried the following code at the PC2 (the same PC as the SQL Server running), and it is running fine. But if I copy the same program and run it at another PC, then it will pop up a "Logon failuer: unknown user name or bad password.".

Microsoft.SqlServer.Management.Common.ServerConnection myServerConn = new Microsoft.SqlServer.Management.Common.ServerConnection();myServerConn.LoginSecure = true;myServerConn.ConnectAsUser = true;myServerConn.ConnectAsUserName = "username";myServerConn.ConnectAsPassword = "myPassword";myServerConn.ServerInstance = "myPCName\mySQLInstance";myServerConn.Connect();


Please help! Thank you!

View 1 Replies View Related

XP_CMDSHELL- Access Denied Accessing Remote Server

Jun 20, 2007

I am using XP_CMDSHELL to run 2 Windows commands (from a SQL 2005 SP2 server) that access files on a remote server (called webserver). The two commands are:

1. cscript.exe \webserverwwwrootEur_SaveProductImages.vbs
2. dir \webserverwwwroot
Up until very recently this worked fine. Now I am getting Access Is Denied errors:

For #1:
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
CScript Error: Loading script "\webserverwwwrootEur_SaveProductImages.vbs" failed (Access is denied. ).

For #2:
Access is denied.

This happens if the above commands are run through a job, or directly with Query Analyzer as SA.

I understand that XP_CMDSHELL commands are run in the security context of the SQL Server startup account. The SQL Server startup account is called SQLServer and this account exists on both webserver and the database server. On both servers the username & password are identical and the user is in the local Administrators group. The two servers are in a workgroup.

Things I have tried (with no effect):

1. Restarted the servers
2. Deleted and recreated the SQLServer login on both servers
3. Changed the startup account for SQL Server through the SQL Server Configuration Manager to another account and back to SQLServer.

The most revealing tests are these:

1. If I log into the database server myself using the SQLServer account I can run the above commands in a Command Prompt with no problem

2. I installed SQL 2005 Express SP2 on webserver using the same startup account (SQLServer). If I run the same XP_CMDSHELL commands as above but accessing files on the database server, the commands work!
So, an XP_CMDSHELL command run under SQL Express using the local SQLServer account to access a remote server works, but an XP_CMDSHELL command run under SQL Server using a local SQLServer account (that is supposedly identical to the same named account on the other server) does not work !!?!?!?

It is almost as if XP_CMDSHELL commands run under SQL Server are NOT using the SQLServer startup account, but using some other weaker account. How can I tell if this is true?

How can I get this back working (as it was a week ago). The only thing I can think that happened on the servers to cause this is the installation of Windows Updates.

Thanks

View 7 Replies View Related

Deploying To Remote Database

May 4, 2006

Hi,
We are using SQL-Server (2005) for the first time and have developed an app that uses 2 dozen tables and a bunch of SP, triggers, etc.
How do we get our entities to our client site without a lot of copying and pasting? How about the data we want to upload for lookup tables - how would we get the data there?
Moreover, how do we sync stored procedures with the live database as we make changes during development?
Thanks,
Mark

View 1 Replies View Related

Problem Reaching Sqlserver2000 Database With Asp.net 2.0 Application When Deploying

Jun 12, 2007

I have developped an ASP.NET 2.0 webb application localy on my workstation and have the MSSQL2000 database on a  server.There has been no problem accessing the database during development. 
Im now finnished and put the application on a web server.
No when i try to access the application i get the following problem as it tries to reach the 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I still use the same database so remote connections are allowed and there are lot of application against that sqlserver already running.
I have anonumouse access and use a domain service account for the application and that very same account is added as a login to the sqlserver and a domainuser in the database.
I have Forms authentication in my web.config file.
the connectionstring i use look like this:
<appSettings> <add key="app1" value="Data Source=server01;Initial Catalog=database1; Integrated Security=SSPI;"/></appSettings>
Can somebody please tell me what is wrong and how to fix it. I dont change any configuration betweeen my workstation and the server in web.config
/ in pain!!

View 1 Replies View Related

Deploying Windows App And A Sql Server Express Database

Apr 29, 2008

Hi there. I've created a windows forms app that connects to a sql server express database. now that it's working on my box, i need to install the entire solution on the end user's machine.
what's the best way to move the database? I found this article:
http://msdn.microsoft.com/en-us/library/ms165716.aspx
but i'm wondering if anyone can give me some insights based on your own experience.
I'm using ms visual studio 2005 and sql server express 2005.
I'm hoping that all i'll really have to do is copy everything over to the new machine and then edit my connection string in the .exe.config file for my app.

Thanks in advance for your help.

View 5 Replies View Related

HELP On Deploying A SQL Database To A Remote Hosting Environment

Apr 4, 2008

hi,I was redirect to this URL* based on Deploying a SQL Database to a Remote Hosting Environment,pertaining to my question on how do I convert MDF file to .SQL.I had downloaded and installed the program recommended that is Database Publishing Wizard.but the problem is now, there isn't any context menu "Publish to Provider" * when i right click on thedatabase aspnetdb.mdf..please advice me. thanks.* Reference : http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx 

View 4 Replies View Related

IBMDASQL OLEDB Linked Server Access Denied Using Windows Authentication

May 15, 2007

I have a linked server defined on a SQL Server 2005 SP2 standard edition server using the IBMDASQL OLEDB driver. The linked server has been defined and working for months when used from a SQL Server authenticated session. I started converting our developers to Windows Authentication and access to the linked server is denied when used from a Windows Authenticated session. Here are the error messages:



Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "IBMDASQL" for linked server "DB2ARUBA" reported an error. Access denied.

Msg 7350, Level 16, State 2, Line 1

Cannot get the column information from OLE DB provider "IBMDASQL" for linked server "DB2ARUBA".



The linked server security is defined to login to the IBM iSeries using a fixed user and password regardless of the login using the linked server.



In order to analyze the problem, I created one sysadmin SQL Server authenticated login and one sysadmin Windows Authenticated login. The Windows Authenticated login refers to a domain login having administrator priviledges on the local SQL Server box.



So, when I connect to SQL Server using the SQL Authenticated login, a query against the linked server works. When I connect to SQL Server using the Windows Authenticated login, the exact same query against the linked server fails with the messages above.



Does anyone know why?

View 10 Replies View Related

Using A Windows Application To Connect To An Online Access DB.

Aug 25, 2007

Hi all,

I'm working on a project where I have to create a password protected form for teachers to submit reports about students.
Originally I was going to use asp.net to create the form, but unfortunately the server I'm working with will not be granted asp functionality in the allotted timeframe.

To solve this issue I have another idea. So I will ask a few questions to help with research before I begin coding.

Is it possible to create a windows application that can connect to an access database hosted online? The windows app will need to be be able to update, insert, and select information from the database.

There is only going to be about 30-40 people using this windows application once or twice a week.

Thus I envision taking a password protected access database and dropping it onto a server.
The windows application will have the online location of the database embeded into the code. (connection string)
From there on out coding for the windows application should be the exact same as if the database was hosted locally on the computer, correct?

Also,
1. What is a good way to check and make sure the computer is connected to the internet before my application tries to access the database?

2. Are there any drastic security issues with this process that I should think about. The database will only be password proected, and the windows application will take a username/password from the user and check it against a table before they are able to submit info to the database.

I just need to be pointed in the right direction for this project.
Thanks.

View 1 Replies View Related

Secure SQL Server Remote Access From ISV Application

May 8, 2007

Hi guys



I'm writing a C# application which connects to a local SQL database for data access. The application connects to SQL Server through windows authentication, but opens up the port and sqlbrowser to others on the network wanting to access the database through SQL Server authentication, and also allows remote users to connect to this server remotely if they have the login and password (and because the port is already open)



I understand this is not secure and open to attack, and am unsure of how to secure these processes without blocking these three types of access, from A.) the local user, B.) the network user and C.) the remote user across the net.



Have researched this a fair bit, but get somewhat lost amongst all the jargon.

View 6 Replies View Related

I Am Accessing Data Using Data Access Pages In IIS 7 To SQL Server 2005 Authentication Is Failing

Feb 5, 2007

is there a step by step paper to get there? here is what i need to consider. I Iwill have many customers that will need their own set of records and access pages "branded for their company" each customer will have many clients. I am hosting this application on a windows 2003 server with SQL 2005 server enterprise.

I am using windows authentication, I have created a username in windows, then i added the windows user in SQL management studio in security, granted "DB Read" and "DB write" and again under the database security tab. still from the web authentication fails. i must be nissing a step or two?

I expect to set up a username for each database as i setup new customers.

View 1 Replies View Related

Remote Access And Windows Firewall

Sep 20, 2006

Hi all,

I have a Windows Server 2003 with SQL Server 2005.
I´ve configured the following itens to allow remote connecitions:

[code]
WORKAROUND
Warning If you use Registry Editor incorrectly, you may cause
serious problems that may require
you to reinstall your operating system. Microsoft cannot
guarantee that you can solve problems that result from using
Registry Editor incorrectly. Use Registry Editor at your own
risk.To work around this problem, follow these steps on the
computer that Windows XP SP2 is installed on:

1. Make sure that the Log On As account for the MSDTC service
is the Network Service account. To do this, follow these steps:
a. Click Start, and then click Run.
b. In the Run dialog box, type Services.msc, and then click OK.
c. In the Services window, locate the Distributed Transaction
Coordinator service under Name in the right pane.
d. Under the Log On As column, see whether the Log On As
account is Network Service or Local System.

If the Log On As account is Network Service, go to step 2.
If the Log On As account is Local System, continue with these steps.
e. Click Start, and then click Run.
f. In the Run dialog box, type cmd, and then click OK.
g. At the command prompt, type Net stop msdtc to stop the MSDTC service.
h. At the command prompt, type Msdtc €“uninstall to remove MSDTC.
i. At the command prompt, type regedit to open Registry Editor.
j. In Registry Editor, locate, and then delete the following subkey:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTC
k. Close Registry Editor.
l. At the command prompt, type Msdtc €“install to install MSDTC.
m. At the command prompt, type Net start msdtc to start
the MSDTC service.

Note The Log On As account for the MSDTC service is set
to the Network Service account.

2. To allow the network transaction, you must enable
MSDTC. To do this, follow these steps:
a. Click Start, and then click Run.
b. In the Run dialog box, type dcomcnfg.exe, and then click OK.
c. In the Component Services window, expand Component
Services, expand Computers, and then expand My Computer.
d. Right-click My Computer, and then click Properties.
e. In the My Computer Properties dialog box, click
Security Configuration on the MSDTC tab.
f. In the Security Configuration dialog box, click to
select the Network DTC Access check box.
g. To allow the distributed transaction to run on this
computer from a remote computer, click to select the Allow Inbound check box.
h. To allow the distributed transaction to run on a
remote computer from this computer, click to select the Allow
Outbound check box.
i. Under the Transaction Manager Communication
group, click to select the No Authentication Required option.
j. In the Security Configuration dialog box, click OK.
k. In the My Computer Properties dialog box, click OK.


3. Configure Windows Firewall to include the MSDTC
program and to include port 135 as an exception. To do this,
follow these steps:

a. Click Start, and then click Run.
b. In the Run dialog box, type Firewall.cpl, and then click OK.
c. In Control Panel, double-click Windows Firewall.
d. In the Windows Firewall dialog box, click Add
Program on the Exceptions tab.
e. In the Add a Program dialog box, click Browse,
and then locate the Msdtc.exe file. By default, the
file is stored in the Installation drive:WindowsSystem32 folder.
f. In the Add a Program dialog box, click OK.
g. In the Windows Firewall dialog box, click to select
the msdtc option in the Programs and Services list.
h. Click Add Port on the Exceptions tab.
i. In the Add a Port dialog box, type 135 in the Port
number text box, and then click to select the TCP option.
j. In the Add a Port dialog box, type a name for the
exception in the Name text box, and then click OK.
k. In the Windows Firewall dialog box, select the name
that you used for the exception in step j in the
Programs and Services list, and then click OK.
[/code]

But, when the Windows firewal on the server is "On", remote connections
are not allowed, despite I´ve configured the Exceptions on the firewall.

Is there another task to solve this problem?

thanx!!!!

View 1 Replies View Related

How Can I Access Data To SQL Server 2005 Using Windows Application,ADO.net And .Net Remoting.

May 3, 2007

How can I access data to SQL server 2005 using Windows form application,ADO.net and .Net remoting?

Can anybody help me? please...

View 5 Replies View Related

Accessing My MS-SQL Database On Remote Web Site

Apr 24, 2008

I've downloaded a copy of Microsoft SQL Server Management Studio Express from MS. Can this product be used to query an SQL database at a web site.
Conversely, is there a command line utility for running SELECT statement queries on my remote web site database?

View 1 Replies View Related

Damaged Accessing Remote SS2005 Database

Jan 1, 2008

I access remote MSSQL Server2005 (SS2005) databse over internet
through SQL Server Management Studio (SSMS) in order to fine tune
ASP.NET website using remote SS2005 database.

Today I could not launch my SSMS
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2616564&SiteID=1

Is it possible that remote server machine or SS2005 damaged my SSMS.
Can it be due to some incompatibilities, virus (I have Norton Antivirus locally) or something else?

I do not have much experience with using SS2005 over internet.
Can you share with me possible practical stories or theory on it?

View 3 Replies View Related

Trying To Create A New User With Windows Authentication For My Sql Database

Dec 30, 2007

I have a website written in asp.net and the current DATABASE logins do not use windows authenticaton. They are for online use only with a username and password.  I'm trying to run my program locally on my machine and access the database locally.  This is very frustrating. I'm able to connect to my database, but I can't login to it.  Here's my connection string from ym webconfig file:
<add name="sqlConnectionString" providerName="System.Data.SqlClient" connectionString="Connect Timeout=8; Initial Catalog=linkexchanger; Data Source=SCOTSQLEXPRESS; "/>
I have the MSSQL engine running and I have connected with the SERVER.  My database is in my directory tree of Microsoft SQL Management Studio Express.  The server is SCOTSQLEXPRESSI have attempted to add a login to my sql database by right clicking on the security folder to create a new login.  My understanding is that under windows, I don't need a uid and pwd in my connection string .  Thus I tried removing all of this just as you see above, and I get an error message every single time I try to create a login with windows authentication.
Can someone please explain how I make this work? 
Thank you.
 Scot

View 1 Replies View Related

Accessing Windows Users Assigned To A Database Role

Mar 3, 2006

Is
there a way to find a list of Windows User accounts that are directly
or indirectly (through Windows Group membership) assigned to a database
role?


I could put work in to CLR programming or using a Linked Server to
Active Directory, but if there is a sys.* view available that can
provide me this
information directly it would be much easier.



I'll be looking into this further myself anyway and posting an answer
if I can find one, but if anyone has suggestions... well, thanks!

View 1 Replies View Related

About Accessing SQL Server2005 Database File From A Remote Computer

Jun 5, 2007

hi every one. i am a new user of asp.net 2.0 using C#  code and i am facing a problem in accessing a  SQL Server2005 database file in the remote computer. i have connected two pc with peer to peer connection and trying to add a databse using the "Add connection" option from the visual studio 2005. in the add connection dialog box it is showing me the remote server and it was supposed to show all the database in that SQL Server when i select one. but when i am choosing the server name it was not showing me anything. by the way i have configuered the surface area for "both TCP/IP and named pipes" and both the pc's server browser is turned on. is it the right way to access a database file from a remote pc or not?? please send me a good solution to do this things and try to explain the codes with example. waiting for response....plz send me the solution.. as soon as possible

View 2 Replies View Related

Connection Failure To SQL Server 2000 In Remote Machine From Application In Windows Server 2003

Dec 25, 2007

Hi!!

I'moving my asp application to a new hosting server.

So when i tried the setup locally with the live DB & application in my test machine...
The DB access is denied when application tries to hit the DB.


DB is in seperate machine with SQL Server 2000 & application(ASP) is in Windows server 2003.....
Kindly help me with your suggestions....on what went wrong?

View 1 Replies View Related

BCP Rejects Database Name With &#34;-&#34; In It

Jun 14, 2002

I used the following command to import a text file:

exec master..xp_cmdshell 'bcp t-est.dbo.test in c:est.csv -c -t, -r -Sserver -Uuser -Ppassword'

I got the following error message:

SQLState = 37000, NativeError = 170
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '-'.

I user SQL 7 SP4.

Is that a known limitation of BCP?

Thanks in advance.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved