T-SQL (SS2K8) :: Cannot Access Server From Client App?

Jan 26, 2015

I have a C# windows app trying to access database based the connection string stored in teh app.config file

Here is my app.config parameters

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="con1" connectionString="data Source=127.0.0.1sinclair;initial catalog=kingsroad;uid=balrock;pwd=123456;integrated security=True" />

</connectionStrings>
</configuration>

The reason I want to put an ip address on connection string i just want to create connection strings as people do in their work. When the app tried access the connection string it gives the error in the attachment.

Because I haven't used this user/password for a long time I'm pretty sure the user name and password is correct but i have the following questions

1. Assume the user and password is incorrect, is there way to reset this?
2. what other configuration that i need to do in order to make teh C# app access this Database?

View 2 Replies


ADVERTISEMENT

How Do I Allow Access To SQL Server On A Different NT Domain From The Client?

Jul 6, 2001

I want to give a client access to a SQL Server 7 database sitting on a different NT domain without setting up a trust relationship between the two domains. Has anyone tried doing this?

View 2 Replies View Related

SQL Server 2005 Client Access

Jan 24, 2008

Hi there

If I give the user access dbo on 1 of the database, when he logon using SQL Server Management Studio for running query etc, can he only see his database instead of other as well system database?

Is there any best practise in term of setting the SQL client for 2005?

Thanks

View 2 Replies View Related

Setting Up Client PC To Access Remote SQL Server

Jul 20, 2006

Hi,

I am a VB6 programmer and I'm really new to SQL Express, I have always used ACCESS because it was so easy to deploy. I've now written a VB6 program which uses SQL Express and I want to know how to deploy it. Basically my PC will host the SQL database as it has SQL Express loaded onto it. I now want to install my EXE onto other Client's PC and have them read/write to the database on my machine.

Besides the EXE program, what software do I need to load onto the Client's PC so they can access my SQLExpress database...? (eg: Net Framework, SQLExpress, etc).

Also, if my machine is called ABC123, in my connectionstring do I just put in

ABC123sqlexpress as the datasource..?. Will this be enough for the other PCs to connect to mine ?

Thanks

View 8 Replies View Related

Client Cannot Access SQL 2005 Express Server

Jun 21, 2007

I've installed SQL 2005 Express, enabled local and Remote connections but my client app cannot connect to the SQL server. I'm getting access denied or SQL does not exists. Any idea's on how to resolve this issue?

View 1 Replies View Related

Client On Domain Cannot Access SQL Server On Workgroup

Oct 12, 2007

Hi,

I have a quick question regarding domains and workgroups.

Currently I am working on an issue in the office of a small business. Right now there are 3 client computers that connect to a dell server running windows std. server 2003. The server has sql running on it that takes care of the invoicing system. Two out of the three work stations are able to use the database fine, but there is one that is unable to connect to the database. The only different that I could find is that the two workstations that DO work are currently set to use a workgroup, whereas the one workstation that does NOT work is set to use a domain...... I tried switching that computer to workgroup, but then I was unable to login as the normal user that I had always logged in as before.....

What can I do to solve this dilemma?

Any help would be greatly appreciated!

I apologize if this is the wrong forum for this, and if it is, if someone would point me to the correct one I would appreciate it.

Thanks
-steve

View 4 Replies View Related

My XP Client Doesn't Access SQL Server 2000

Aug 9, 2006

Hi,
I have a server (WIN 2000 server), is connected with many clients mostly having Win 2000 Professional OS. My application is developed in VB 6.0 and we have MS SQL Server 2000 DB in our server. All the clients with win 2000 professional have no problem with connecting and accessing my SQL Database. But few of my WIN XP clients don€™t connect to database thru my application. It gives error as follows.

Runtime error
Login Failed for user €˜(null)€™ . Reason: Not associated with a trusted SQL Connection.

Can anyone help me?

Regards
Ahmed Sahib

View 6 Replies View Related

How To Set My ASP.NET Application To Access SQL Server 2005 Using Client's User Credentials?

Jan 29, 2007

Hi guys,I'm not sure if I'm just bad at googling but I can't seem to find a way to set an ASP.NET 2.0 web application to connect to SQL Server 2005 using the current client's user credentials. My web application is using Integrated Windows Authentication so its Page.User.Identity is set to a DOMAINusername value... I want to pass that to my connectionstring or have my connections pick up the identity automatically and use that Identity when accessing the db server.Oh and another thing, my IIS Application Pool is using a specific Identity itself, so I don't know if that might affect the above.Hope someone could help. 

View 2 Replies View Related

T-SQL (SS2K8) :: How To Create Login For Client App

Jan 30, 2015

I have a client application written from C#/winforms app that needs access SQL DB on SQL server 2008 R2 developer. So I need to create a Login for this app with a user/password. But when i created it and put it on the client's connection string, the DB could not be accessed by the client windows forms app and the error was "Login failed for User App1".

Then I tried to login to SQL server from SSMS using the credentials of App1 but it also gave same error "Login failed for user App1". I have following the following steps of creation of the login for App1. i could login from "sa" account and other Admin accounts but not from "App1" account

1. created a server level Login
2. created a DB level user
3. created a Role (a DB role), i even tried creating an App Role
4. given permission to execute stored procedures that handle login

But didn't work. Maybe i made some mistakes in those step. So, how to create an account for user "App1" so it can be accessed by the client windows app and also from SSMS? i would prefer to use account creation from SSMS GUI.

How do i install SQL server 2008R2 in local machine with network accessibility features?

View 1 Replies View Related

T-SQL (SS2K8) :: Is Comparison Of Hash Passwords Happens At Client Or DB Level

Jun 18, 2014

I was told that the authentication is a process that concerns about security. So the authentication process should be hidden from the client as possible and the client should receive a flag value (1= password is correct and authenticated, -1= incorrect password) and/or user name of the authenticated user. So it should be a SQL operation that should occur in the back end. So the process in detail should be, client form sends user name and hashed /encrypted password to SQL, SQL authenticates and it sends 1/-1 with the user name to the client as the return value and the output.

But when i do research that was not the case, all the threads i have seen on web, either the app is windows or web, developers do two operations:

1. the salt value of the user is searched by user name then return the salt value along with the PasswordHash to the client form / or to the business layer

2. Then use the entered password and the returned salt value to generate a PasswordHash and then compare this passwordHash with the returned passwordHash. if match password is correct if not password is incorrect.

Is this actually how developers write code to authenticate a user in a login event? If so basically the password comparison happens at the client side(either in the form or in the business layer) then wouldn't this be huge security risk by exposing the actual salt and passwordHash to the client?

View 5 Replies View Related

T-SQL (SS2K8) :: Export Data To Client Remote Desktop?

Feb 26, 2015

I need to write a stored procedure or SSIS to export data to client's desktop. What is the best way to achieve it?

The requirement is to develop a web application the client can click on the button and the file will be saved to the clients' local C drive.

How should I configure the destination path here?

View 3 Replies View Related

Client Unable To Establish Connection Encryption Not Supported On SQL Server. (Microsoft SQL Native Client)

May 2, 2006

On Windows XP systems I get the following issue when trying to browse the MSDB folder in SSIS

Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)

I have noticed another post where several others have noticed the same issue. It appears to only occur on Windows XP installations. Is there a workaround or fix for this?

View 2 Replies View Related

Client Access Lisences

Dec 14, 2000

Hi,

My department has some questions about Client Access Lisences. Specifcally, they want a definition of what does and does not require a CAL,
and they want something somewhat official. I checked the MSKB, and looked on their sales website, but all I can find is the EULA, and that doesn't help
me all that much.

Does anyone else have this information?

Joe

View 2 Replies View Related

VERY Slow Client Access

Jan 28, 2002

I am experiencing VERY slow connectivity between client and server SQL 2000. I have checked the network activity and it is low. It also takes Enterprise manager ages to load, and then browsing tables and trees is impossible!

HELP!!

View 1 Replies View Related

Access Client Problem

May 9, 2001

Hello everybody,



I recently made a DTS-package from importing external data in my sql2k
server.
I linked my access file to the sql server to make some reports.

Right now, my clients run the dtsrun utility through a batch file
themselves. I gave them permissions to be the dbase owner.

Now when you link from access to sql server as admin, your names are :
dbo_Tablename.
If it's another user, the names get pvanmoer_Tablename and for another user
it's cvanho_Tablename.
(Validation through NT)
So my linked tablenames aren't valid anymore in my access file. So I need
to relink them each time.

How can I avoid this problem ? I've been trying to create tables without
dbaseowner, but this doesn't seem to work.

Can anyone help me ?

Thanks,


Bjorn

View 2 Replies View Related

Restrict Client Access

May 27, 2005

Hello Everybody,

I need some help.
When we install the Database at the clients end, the client can see all
the SQL tables, views and stored procedure in the Enterprise Manager.
Is there a way via which you can restrict the client from viewing the
tables in SQL Enterprise manager?

I hope you understand my question.
I would be oblidged if my friends could help me...

Thanks

View 1 Replies View Related

Refresh Access Client

Nov 18, 2005

Is there a way to update data on a MS Access 2000 client from SQL Server without polling a table using the form's onTimer event?

It would be much more elegant if I could push the data to the clients every 15-30 minutes when the data on SQL Server gets refreshed.

Can DTS do this? The forms I'm talking about are select only, no editing.

I know I can do this with java and multicasting, should work with MM Flash as well with listeners. I would really like to take this app to Flash, but we have a 1 month timeline to port from Access to SQL Server.

Thanks,
Carl

View 5 Replies View Related

Question Regarding Client Access

Jan 21, 2008

Hi,
We're *very* new to using SQL Server and are just getting it up and running. We're only running simple queries right now, but we're doing so by connecting to our server via 'Remote Desktop' to run the management studio to run the queries.

Is there an SQL client that can be installed on a user's workstation that will allow them to run queries without having to use a 'Remote Desktop' connection on the server?



Thanks,
James

View 3 Replies View Related

DTS Scheduling OLE Db Error - DB2 Client Access

Feb 13, 2000

I have a DTS package that executes when run manually. It is a OLEdb (ODBC) to client access (db2). When I try to schedule it the package fails.

Other packages SQL - SQL are fine to schedule or to run man.

I have played with the Persist Security Info advanced properties of the connection to no avail.

Any assistance would be great.

Thanks

Robb M Sinclair
Newcomp Solutions Inc

View 2 Replies View Related

SQL2000 Vs SQL6.5 Client Access

Sep 18, 2001

I'm thinking to upgrade SQL6.5 DB to SQL 2000 but do not know
all client access with SQL 6.5 utility will work ???
(The application is a vendor canned package using SQL 7.0 DB
but client can access with 6.5 ---Not using ODBC)
Any experts can help ?
Thank you in advance !!

Lewis

View 1 Replies View Related

Client Able To Access SSAS Cube Only Once

Sep 6, 2007

I have an excel workbook, that has a pivot table in it where the data source is an OLAP cube. My problem occurs on the client machine, logged in as the client. I remote into the PC, and create a pivot table using the OLAP cube connection. I create the pivot table and everything works fine - I am able to browse the data with no issues. Once I exit the Excel Workbook, and come back in - I am no longer able to connect to the datasource. I have tried both saving the password in the connection and not saving it. It has made no difference.

View 1 Replies View Related

Access A Database From A Client Application

Oct 18, 2006

Hi all...

I am writing a Windows Application which will be used by about 100 clients. (NT Authenticated)

The application is going to be used in a LAN enviroment. User who have access will download a VB.NET application from a web site.

Of course, I want to prevent any of the 100 users from using a tool such as Query Analysis or ODBC to connect directly to the database and modify data.

So, it appears the way to go is to the "Application Roles". For this to work, the application roll password has to be saved in the application to execute the sp_setapprole procedure.

Is there a way to secure this password? I am worried about a user somehow extracting the password from the application and connecting directly.

Am I on the right track here? Any ideas appreciated!

Thanks,

Forch

View 4 Replies View Related

Unable To Access MSSQLSERVER From Client

Dec 20, 2005

Hi,

I have SQL Server 2005 installed and functioning (it does everything I've asked it to do locally). I also have the Express and Standard Editions installed on a computer running WinXPPro SP2 with all the WinUpdates applied. I also have VS2005 installed on this computer. I've done some development work on this computer, using VS2005 to create a SQLDB, connect to it, add data, etc. This is all okay.

The problem is I cannot connect to the SQL Server from the client computer. I installed the client tools on this XP Pro box along with all the WinUpdates. Here's what I can do...

I can ping the SQL Server by name (the name gets resolved).
I can copy files between the two computers using Explorer.
I enabled "Allow remote connections to this server" in the Server Properties / Connections page.
I did not change the default port of 1433.
The TCP/IP protocal is enabled in the Configuration Manager.
The Surface Area has been configured to allow local and remote connections using TCP/IP and named pipes.
SQLBrowser surface is running as is the MSSQLSERVER service.

So what's going on? I am new to SQL Server to it may be something very simple / obvious.

Thanks for your help,
Scott

 

View 4 Replies View Related

Looking For Mentor (service) For Help Designing Web Client For DB Access

Apr 24, 2008

I work at a place that does device testing where the test results are saved in a SQL database. I have an objective to create a plan for a pilot project to place the data on our intranet so our engineering dept can research test results.

I'm trying to find some group I can beg / borrow / pay to look at our schema and help me chart out what tools we should use and how much (ballpark) work is involved.

I'm a VB.NET developer. I did a tutorial on SQL Reporting Services and see potential there. I skimmed a tutorial on SQL Analysis services, and like the idea of being able to trend our data. But it's over my head at this point to get from where I'd like to be to what Microsoft tools to use and how to put them together.

I contacted one local DB/Developer shop and they wanted to bring in a team of engineers for two days and charge us $6000 for a "total solution". Instead of that, I'd like to maybe spend an hour on the phone and some emails to send a schema to someone who knew the tools inside/out and get a pretty good recommendation for a reasonable price.

Any ideas on how I can find such help?

thanks much - Mark

View 2 Replies View Related

Client Access Licenses Needed For Sql Express Or Not

May 4, 2007

we have a sql express - that comes standard with servers.I just wanted to know.....Is there any addition Client access licenses needed for this sql express or not.

View 1 Replies View Related

Cant Get Access Database Synchronizer Set Up On Client Machine

Apr 17, 2007



I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation.



His "Computer Name" as it's stated in his 'My Computer' properties is "PAVSGP024FE.NWFSC.NOAA.GOV"



However his Access.MDW File is located in the directory "C:Documents and SettingsJoe NobodyApplication DataMicrosoftAccessSystem.MDW".



There is no directory called "C:Documents and SettingsPAVSGP024FE.NWFSC.NOAA.GOVApplication DataMicrosoftAccessSystem.MDW".



His current config.xml file looks like this.



<?xml version="1.0" encoding="UTF-8"?>
<SystemNode>
<AccessDB>C:Program FilesNOAA Release LoggerNOAA_ReleaseLogger.mdb</AccessDB>
<DeviceDB>Program FilesNOAA Release LoggerNOAA_ReleaseLogger.sdf</DeviceDB>
<Login>Joe Nobody</Login>
<URL>http://Joe Nobody:1024/</URL>
<WinDir>C:</WinDir>
</SystemNode>



He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http://PAVSGP024FE.NWFSC.NOAA.GOV:1024/</URL> but this throws the error



"The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]"



I dont know what else to try! Anybody have any suggestions?

View 5 Replies View Related

How To Access To Excel,csv Or Other Formatted File Using OLE DB(SQL Native Client)?

Apr 13, 2007

Hi~.

First, is it possible to access(read/write) to the excel,csv or my-own-formatted file using OLE DB(SQL Native Client)?



If possible, how?

View 1 Replies View Related

How To Access Output (Inserted.ColName) From Client Application ?

Nov 6, 2006

I am using SQL Express 2005 and VB .net Express.

Question 1:

How can I get the result stored in Inserted.ColName (by Output clause of insert command). In the documentation (BOL) for SQL 2005, there is written "returned to the processing application for use" in Output clause (first paragraph).

Question 2:

How to store Inserted.ColName into local variable when insert command is running in stored procedure.:

View 8 Replies View Related

Data Access :: Client Disconnect Happens Every Day At Particular Time Window?

Nov 11, 2015

Every day between 1AM to 2AM client disconnect happens and it's not too long also...it's about 30secs...nothing is recorded from SQL side and application server side and then we checked the network...there is no disconnect from network side too. How can i find the cause for disconnect. 

View 4 Replies View Related

Help Usign GetDate() On A SQL DTS With IBM ISeries Client Access ODBC Driver

Oct 21, 2004

I have created a DTS package in SQL 2000 that connects to AS/400 via IBM iSeries Client Access ODBC drivers version R52. I got an error everytime I tried to use the GETDATE() function as follow:

Error Source : Microsoft OLE DB Provider for ODBC Drivers
Error Description : [IBM][iSeries ODBC Driver][DB@ UDB]SQL0204 - GETDATE in *LIBL Type *N not found

Can someone help?

Victor

View 1 Replies View Related

User Is Rejected To Access Database From Crystal Report Client And Services...!

Dec 18, 2007

We are using Crystal Report Services XI to generate reports from SQL Server 2000 database running on server within the same domain (LAN).

for some reason, SQL Server is rejecting the Credentials that is provided to CR Services, the user has right to that database. When We run the report manual, it works fine, but when we run Automatic on schedule , it fails.

The Authentication mode is set to Mixed.

The Startup Service accoutn is set to "This Account"

Any idea, why would this failure on User is encoutered.

Thanks,

View 1 Replies View Related

T-SQL (SS2K8) :: Access EXCEL Using OPENROWSET

May 22, 2014

I'm trying to access Excel file from SQL Server management studio using OPENROWSET using the below query but getting the error listed below.

Query:
SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0 Xml;HDR=YES;Database=E:TestFilesExcelFile.xlsx',
'SELECT * FROM [Sheet1$]'
)

Error:
Msg 7415, Level 16, State 1, Line 2
Ad hoc access to OLE DB provider 'Microsoft.ACE.OLEDB.12.0' has been denied. You must access this provider through a linked server.

View 9 Replies View Related

Creating Access To Native Client OLE DB Provider Using CoCreateInstance Fails With 80040154 Error?

Nov 22, 2015

I am trying to obtain access to SQL Server Native Client OLE DB provider using :

hr = CoCreateInstance(CLSID_SQLNCLI11, NULL, CLSCTX_INPROC_SERVER, IID_IDBInitialize,
(void **) &PIDBInitialize);

and this fails with 80040154 error. I am using sqlserver 2012 and everything worked perfectly fine as long as my application was running on the same machine as sql server was installed but now that the app is deployed in a different environment in which the app runs on a separate server than the server which has the database and sql server I am failing with this error even though the sql server version on the target server is same as mine.

View 3 Replies View Related







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