Hi all!
I am having a rather odd issue with VB.Net (Visual Studio 2005) and SQL
Server 2005. I developed a little app for our team but then decided to
make it available for others. Since out team was given admin rights to
our database, I used integrated security for the first version of the
app. When I opened it up to other groups, I changed to SQL
authentication.
The problem is that no one outside our group has been able to use the
app because of DB connection issues. It always works from my machine,
so I checked the activity monitor on the server. Sure enough, I am
logged in as myself instead of the user I set up for the application.
Here is the connection string:
Private m_SQLConStr As String = "Data Source=MYDB;Initial
Catalog=MYDATA;Integrated Security=False;Persist Security
Info=False;User ID=MYUSER;Password=MYPASSWORD"
Does anyone have any insight into this problem?
Thanks! 6 2990
2 choices:
a) move to mySql; where username/password security is secure. MS SQL
Authentication is _IMPOSSIBLE_ to secure
b) enable double-hop authenticaiton for SQL Server; setspn and 'trust
for delegation'
-Aaron
Tony wrote:
Hi all!
I am having a rather odd issue with VB.Net (Visual Studio 2005) and SQL
Server 2005. I developed a little app for our team but then decided to
make it available for others. Since out team was given admin rights to
our database, I used integrated security for the first version of the
app. When I opened it up to other groups, I changed to SQL
authentication.
The problem is that no one outside our group has been able to use the
app because of DB connection issues. It always works from my machine,
so I checked the activity monitor on the server. Sure enough, I am
logged in as myself instead of the user I set up for the application.
Here is the connection string:
Private m_SQLConStr As String = "Data Source=MYDB;Initial
Catalog=MYDATA;Integrated Security=False;Persist Security
Info=False;User ID=MYUSER;Password=MYPASSWORD"
Does anyone have any insight into this problem?
Thanks!
Hi,
Can you modify your connection string to look like this and see if it works:
Private m_SQLConStr As String = "Data Source=MYDB;Initial
Catalog=MYDATA;User Id=MYUSER;Password=MYPASSWORD;"
You can also try:
Private m_SQLConStr As String = "Server=MYDB;Database=MYDATA;User
ID=MYUSER;Password=MYPASSWORD;Trusted_Connection=F alse;"
Regards,
Plamen Ratchev http://www.SQLStudio.com
"Tony" <sc******@computer.orgwrote in message
news:11*********************@80g2000cwy.googlegrou ps.com...
Hi all!
I am having a rather odd issue with VB.Net (Visual Studio 2005) and SQL
Server 2005. I developed a little app for our team but then decided to
make it available for others. Since out team was given admin rights to
our database, I used integrated security for the first version of the
app. When I opened it up to other groups, I changed to SQL
authentication.
The problem is that no one outside our group has been able to use the
app because of DB connection issues. It always works from my machine,
so I checked the activity monitor on the server. Sure enough, I am
logged in as myself instead of the user I set up for the application.
Here is the connection string:
Private m_SQLConStr As String = "Data Source=MYDB;Initial
Catalog=MYDATA;Integrated Security=False;Persist Security
Info=False;User ID=MYUSER;Password=MYPASSWORD"
Does anyone have any insight into this problem?
Thanks!
Hi!
I have added the trusted source section to the string so it looks like
the following:
"Data Source=MYDB;Initial Catalog=MYDATA;Integrated
Security=False;Persist Security Info=False;User
ID=MYUSER;Password=MYPASSWORD;Trusted_Connection=F alse;"
It is STILL connecting as my login. This is very irritating. Does
anyone have any more suggestions?
Plamen Ratchev wrote:
Hi,
Can you modify your connection string to look like this and see if it works:
Private m_SQLConStr As String = "Data Source=MYDB;Initial
Catalog=MYDATA;User Id=MYUSER;Password=MYPASSWORD;"
You can also try:
Private m_SQLConStr As String = "Server=MYDB;Database=MYDATA;User
ID=MYUSER;Password=MYPASSWORD;Trusted_Connection=F alse;"
Regards,
Plamen Ratchev http://www.SQLStudio.com
Thanks,
Tony
I dont think that you need the integrated_security = false
screw this whole thread
a) make a new text file
b) rename it to test.udl
c) double click on it.. setup connection.. hit apply / ok -- however
you want to do it.
d) rename it from text.udl to test.txt
e) open it with notepad and you've got a REAL CONNECTION STRING
-Aaron
Tony wrote:
Hi!
I have added the trusted source section to the string so it looks like
the following:
"Data Source=MYDB;Initial Catalog=MYDATA;Integrated
Security=False;Persist Security Info=False;User
ID=MYUSER;Password=MYPASSWORD;Trusted_Connection=F alse;"
It is STILL connecting as my login. This is very irritating. Does
anyone have any more suggestions?
Plamen Ratchev wrote:
Hi,
Can you modify your connection string to look like this and see if it works:
Private m_SQLConStr As String = "Data Source=MYDB;Initial
Catalog=MYDATA;User Id=MYUSER;Password=MYPASSWORD;"
You can also try:
Private m_SQLConStr As String = "Server=MYDB;Database=MYDATA;User
ID=MYUSER;Password=MYPASSWORD;Trusted_Connection=F alse;"
Regards,
Plamen Ratchev http://www.SQLStudio.com
Thanks,
Tony
Is it possible that you have defined connection strings on two locations in
your code and not using the correct one?
Regards,
Plamen Ratchev http://www.SQLStudio.com
"Tony" <sc******@computer.orgwrote in message
news:11*********************@80g2000cwy.googlegrou ps.com...
Hi!
I have added the trusted source section to the string so it looks like
the following:
"Data Source=MYDB;Initial Catalog=MYDATA;Integrated
Security=False;Persist Security Info=False;User
ID=MYUSER;Password=MYPASSWORD;Trusted_Connection=F alse;"
It is STILL connecting as my login. This is very irritating. Does
anyone have any more suggestions?
Plamen Ratchev wrote:
>Hi,
Can you modify your connection string to look like this and see if it works:
Private m_SQLConStr As String = "Data Source=MYDB;Initial Catalog=MYDATA;User Id=MYUSER;Password=MYPASSWORD;"
You can also try:
Private m_SQLConStr As String = "Server=MYDB;Database=MYDATA;User ID=MYUSER;Password=MYPASSWORD;Trusted_Connection= False;"
Regards,
Plamen Ratchev http://www.SQLStudio.com
Thanks,
Tony
Hey! Neat trick! It didn't directly solve my problem, but it did throw
an error which helped me diagnose the issue. It seems that the admin
had only set the database to allow integrated security connections. I
guess that my attempts to log in as a specific user failed, and the
system just used a trusted connection instead. I hate it when computers
try to be helpful.
Thanks everyone! aa*********@gmail.com wrote:
I dont think that you need the integrated_security = false
screw this whole thread
a) make a new text file
b) rename it to test.udl
c) double click on it.. setup connection.. hit apply / ok -- however
you want to do it.
d) rename it from text.udl to test.txt
e) open it with notepad and you've got a REAL CONNECTION STRING
-Aaron
Tony wrote:
Hi!
I have added the trusted source section to the string so it looks like
the following:
"Data Source=MYDB;Initial Catalog=MYDATA;Integrated
Security=False;Persist Security Info=False;User
ID=MYUSER;Password=MYPASSWORD;Trusted_Connection=F alse;"
It is STILL connecting as my login. This is very irritating. Does
anyone have any more suggestions?
Plamen Ratchev wrote:
Hi,
>
Can you modify your connection string to look like this and see if it works:
>
Private m_SQLConStr As String = "Data Source=MYDB;Initial
Catalog=MYDATA;User Id=MYUSER;Password=MYPASSWORD;"
>
You can also try:
>
Private m_SQLConStr As String = "Server=MYDB;Database=MYDATA;User
ID=MYUSER;Password=MYPASSWORD;Trusted_Connection=F alse;"
>
Regards,
>
Plamen Ratchev http://www.SQLStudio.com
>
Thanks,
Tony
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Syed Naveed Ausaf |
last post by:
Hi all,
My scenario is this:
Central Server: on which a number of remote machines invoke services
(implemented as web services, but doesn't matter what the choice of
implementation is).
...
|
by: RedEye |
last post by:
Hello,
I am working on a test site to explore the new login controls and membership
features of ASP.NET v2.0. I have tested the controls using SQL Express and
have now decided to try using a...
|
by: Alice Wong |
last post by:
I am setting up my Web ASP.net application to connect to Sql server using
windows authentication.
I set up IIS to have integrated windows authenication and sql to allow
Windows authentication....
|
by: pb648174 |
last post by:
I have a web server and database server which are not on a domain. The
web server has an app that is running on under the IUSR account and
there is a corresponding IUSR account on the database...
|
by: Adrian Parker |
last post by:
Have two domains, which are non-trusted.. and will never be I've been told.
Users on one domain need to access a website on the other domain, but don't
want to have to enter any credentials as...
|
by: Marc Castrechini |
last post by:
This is a classic double hop delegation issue, however its the first time we
are setting this up so we are doing something incorrectly. If we run
through the IDE or using a localhost path on the...
|
by: Dean Craig |
last post by:
I'm getting ready to build my first ASP.NET/SQL Server website that will be
hosted on some web host out there (long distance, different network). The
work I've done in the past (pre-.NET) was all...
|
by: troywalker |
last post by:
I am new to LDAP and Directory Services, and I have a project that
requires me to authenticate users against a Sun Java System Directory
Server in order to access the application. I have found...
|
by: Rory Becker |
last post by:
Having now created a Custom MembershipProvider that seems to work correctly
with my Logon and ChangePassword controls, I am, as they say, a happy bunny.
The next stange is to move on to the...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |