473,699 Members | 2,552 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Visual Studio .NET development environment

Last week I asked a question about connection to database from client machine
(developer machine). There are two types of security setup for SQL Server
database: Windows only and "SQL
Server and Windows" under (local)Windows NT node of Enterprise Manager.

-----
First, I set the database security as "SQL
Server and Windows" under (local)Windows NT node of Enterprise Manager.
However, I could not setup a database connection to Server from Client using
Server Explorer of Visual Studio 2005. The detail is in the following.

Configuration of server and client:

Server: Windows Server 2000, SQL Server 2000
Authentication method: Active Directory Users and Computers (It is my first
time to use it)
User acount MyName with Admin role
User in database: domainName\MyNa me
SQL Server database security setup: "SQL Server and Windows" under
(local)Windows NT node

Client: Windows XP pro, Visual Studio 2005 pro

Operation for database connection on client side:

1. Open Server Explorer on Visual Studio.
2. Add connection
3. Select Microsoft SQL Server and Continue
4. Select Server name: Server computer name
5. Select "use SQL Server authentication"
6. Type in User Name: "DomainName\MyN ame" or "MyName" (either not work!)
7. Type in User password: my windows server password
8. Test Connection
9. Error message: Login fails for user 'MyName' (or 'DomainName\MyN ame')

----
Second, I set the database security (Authentication ) as "Windows Only".
Operation for database connection on client side:
Case 1: Select "use Windows authentication"
1. Open Server Explorer on Visual Studio.
2. Add connection
3. Select Microsoft SQL Server and Continue
4. Select Server name: Server computer name
5. Select "use Windows authentication"
6. Test Connection
7. Error message: Login failed for user '(null)' , Reason:not associated
with a trusted SQL Server Connection.
NOTE: I can not type in any userID and password (grey). In Advanced, I can
not type in userID and password either.

Case 2: Select "use SQL Server authentication"
1. Open Server Explorer on Visual Studio.
2. Add connection
3. Select Microsoft SQL Server and Continue
4. Select Server name: Server computer name
5. Select "use SQL Server authentication"
6. Type in User Name: "MyName"
7. Type in User password: my windows server password
8. Test Connection
9. Error message: Login failed for user 'MyName' , Reason:not associated
with a trusted SQL Server Connection.

Thanks for any help

David
Oct 24 '07 #1
0 1244

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1501
by: micc | last post by:
I am using devenv to build a solution. The Solution comprises 2 projects :- one C++ and the other a Fortran project. I created this solution by automatically converting a Visual Studio version 6 project. When I build the solution in a Visual Studio .NET workspace, it builds successfully with no errors in either project.
63
5906
by: Jerome | last post by:
Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy in Visual Studio to create reports and labels as it's in Access?` The advantage of VS.net is that not every user needs Access, right? And that would eliminate the Access version problem as well I guess.
4
1849
by: wASP | last post by:
Hi, I am contemplating the purchase of Microsoft Visual Studio .NET, and I've noticed that the prices range anywhere from $200 to $600 USD: <+>-<+>-<+>-<+>-<+>-<+>-<+>-<+>-<+>-<+>-<+>-<+>-<+>-<+>-<+>-<+>-<+>-<+> http://www.calibex.com/Microsoft-Visual-Studio-NET--zz57175175z0znz1zvisual _studio_netzcalibex1zB9bz2--COMPARE-PRICES-html Microsoft Visual Studio .NET Lowest Price:
4
1684
by: RossettoeCioccolato | last post by:
I don't suppose that we have made any progress--since I last asked this question about a year ago--towards integrating driver development into the Visual Studio 8.0 build environment. The new compiler is stricter/does a much better job at spotting compile time errors than the compiler distributed with the DDK. I would much prefer to use it. After having reviewed the build log from DDKBuild it doesn't seem like this is rocket science. ...
0
3345
by: fiona | last post by:
Innovasys Ltd., a leader in help authoring and documentation tools, today announced the inclusion of a tailored version of the Innovasys HelpStudio help authoring product, HelpStudio Lite, in the Microsoft Visual Studio 2005 Software Development Kit. By providing a full help authoring environment within the Visual Studio 2005 SDK, Innovasys is providing developers building components and products that integrate with Visual Studio 2005 a...
4
1941
by: Ben Kim | last post by:
Hello all, I have VS 2005 and SQL 2005 installed on my machine. However the "Getting Started" area of the Start Page shows SQL information instead of Visual Studio information when I start up Visual Studio 2005. Is there any way to reset the link to VS related info? I have tried reinstalling, uninstalling and reinstalling and it appears the installer does not remove the link from the registry. Any ideas would be appreciated.
3
2063
by: RS | last post by:
Hi all, My code compiles well with gcc on linux and OS X, but now I have to run it at work, and my only choice is Visual Studio .Net 2003 environment on windows, which I had never used before. I've noticed several obstacles with the compilation. For example this environment insists that we put all headers under a stdafx header, which I managed to find a way to get around. But there are other issues. For example, Visual Studio claims...
13
3024
by: Mark Rae | last post by:
Hi, On Friday I attended the Microsoft EVO conference in London where they talked about Vista, Office 2007 and Exchange 2007 and how they all work together beautifully, how they were all "people-ready" etc... I asked a couple of questions about Visual Studio.NET on Vista, especially on 64-bit Vista, and they became *very* nervous... To cut a long story short, Microsoft will not support ANY version of Visual
13
4373
by: jc | last post by:
I have written a parser using bison and flex to read ASAP2 file for CAN communications. entire development was done in an unix environment and now the code is ready to be integrated to an existing CAN communication software that i wrote earlier in windows environment(as we get drivers for these CAN cards only for the windows). my problem started when i started to move the code from linux to the visual studio. after many compilation and...
7
1828
by: Chris Marsh | last post by:
All I've been asked run a VM on my development machine, with Windows Server 2003 installed. I've also been asked to then develop against this environment from the host machine, using Visual Studio 2003. Questions: 1. Is it even possible to use VS 2003 to develop when all files and IIS are on a remote machine or VM?
0
8617
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9174
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8884
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7751
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6534
isladogs
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5875
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3057
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2347
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2009
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.