Tag: connection

this user is not associated

Machine X (hoster pc with SQL Server 2005 Express edition installed and also known as development PC) Machine Y (unknown user or guest) I can both set and get data from machine X but when friends try to do that they get the following error the user is not associated with a trusted sql server […]

Unable to connect to SQL Server in Hydro GeoAnalyst

I have installed Hydro GeoAnalyst 2014.2 and i have started trial and wanted to install demo project. Firstly, i must select data source type, available server and database name. I select data soruce type, then i write sql server instance name and then related combobox filled my databases. Finally, i select my database. I use […]

how to know client ip port from jdbc connection

I am testing about MSSQL. “how to long session information created after after connection?” So, try to connection with MSSQL JDBC, then select the sys.dm_exec_session and sys.dm_exec_connection with client Ip and port. But, I don’t have any idea, how to get Client Ip and port from JDBC connection. or is it possible create JDBC connection […]

C# : Application doesn't access database in client pc

I have installed sql server in client pc but the app doesn’t access database. this is my connection string : connectionString=”Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\myDB.mdf;Integrated Security=True;User Instance=True” please, is there other apps must be installed in client pc (e.g., SSMS)?

Can't connect to SQL Server 2005

I just installed SQL Server 2005 on my machine and now I am trying to connect to it via SQuirrel SQL, but I am unfortunately running into problems. When installing SQL Server 2005 I chose mixed mode for authentication and I have set up a new user account with which I am trying to connect. […]

Can't connect to Sql Server database with Netbeans

I’m trying to make a connection database SQL Server 2012 with Netbeans 8.2 Using the connection wizard I select Sql Server 2012 and enter the credentials and fields. However I get the message that a connection cannot be established. You can see screenshots of the entered fields: Full Resolution

Where/How do I handle different connection types using Repository Pattern with ADO.Net?

I am new to the repository pattern but am creating a repository to connect to two different database types that have the same data structure. Where and how should I handle the connection? Here are my requirements/constraints/project description I will be connecting to SQL Server 2005 and DB2 (on Iseries) I will be using the […]

SQL Agent Job – Connection may not be configured correctly or you may not have the right permissions on this connection?

I’m getting this error when running an SSIS package through SQL Agent Failed to acquire connection “ORACLE ADO.NET”. Connection may not be configured correctly or you may not have the right permissions on this connection. When I log on as the SQL Agent User and run the ssis package directly it is fine. When I […]

Connect to database using sql server remotely

I have finished a program using sql server and visual studio using c# language . I want to put the database on pc and the program that connected to that database on other PCs I’m using this connection string in App.config : <connectionStrings> <add name=”MWEConnectionString” connectionString =”integrated security=yes;initial catalog=MWDB;data source=.\sqlexpress”/> </connectionStrings> Should I change server […]

How to use system_user in audit trigger but still use connection pooling?

I would like to do both of the following things: use audit triggers on my database tables to identify which user updated what; use connection pooling to improve performance For #1, I use ‘system_user’ in the database trigger to identify the user making the change, but this prevent me from doing #2 which requires a […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.