|
NT integrated security is basically just using usernames on your machine (or in active directory) as opposed to the SQL server holding login information etc.
As for SQL Server you should see if you can get a developer license copy of SQL Server 2000 (you can usually get these pretty cheap or free if you have MSDN) Otherwise check out Christian Graus's article Over here[^] he has made a tool for configuring/working with MSDE.
If you are working with C# and SQL server you may want to check out my article[^] on using SQL in C#.
Matt Newman
|
|
|
|
|
Matt, thanks for the reply. As I purchased Architect, and due to Microsoft's specs, I am under the impression I should already have developer license copy of SQL Server 2000 ... but during the install I was told to go download it, some SP3a version.
Anyway, I appreciate the links and will check things out.
Thanks again.
|
|
|
|
|
Well, I'm afraid I'm still lost.
The only way I can get anything to work at all appears to be to enter NAMEOFMYWORKSTATION\VSDOTNET for the Server Name. I am then limited to databases master, model, msdb and tempdb and cannot in any way specify the pubs database as suggested in the walkthrough.
This is as true of Graus's MSDEGUI as VS.
(Perhaps you are beginning to truly understand what a dumb newbie I really am.)
Anyway, a post on one of the newsgroups said that a developer license copy of SQL Server 2000 should have been included with Architect -- not just directions to go download and install MSDE, and if it was not, to contact Microsoft's Product Order Desk. Can anyone confirm whether that is true or not?
And would having it help me any over MSDE? -- or is there simply no cure for this kind of stupidity?
|
|
|
|
|
the_ol_bonehead wrote:
The only way I can get anything to work at all appears to be to enter NAMEOFMYWORKSTATION\VSDOTNET for the Server Name. I am then limited to databases master, model, msdb and tempdb and cannot in any way specify the pubs database as suggested in the walkthrough.
The pubs database may not be set up in MSDE 
the_ol_bonehead wrote:
And would having it help me any over MSDE? -- or is there simply no cure for this kind of stupidity?
Definitely. SQL Server 2000 has a tools supplied to work with it via gui. I have to say you have done better getting MSDE actually working. Something I was never able to do. I was lucky enough to get a Academic MSDN license and a copy of SQL 2000.
Matt Newman
|
|
|
|
|
Matt Newman wrote:
The pubs database may not be set up in MSDE
Any advice on doing this would be extremely appreciated.
Matt Newman wrote:
I have to say you have done better getting MSDE actually working.
Very kind of you to say, but I don't feel much of anything right now but frustration. I guess I'll be calling Microsoft tomorrow about SQL 2000 ... hope they will help.
Much thanks for your assistance.
|
|
|
|
|
When you install MSDE through VS.NET, it automatically names the instance of SQL Server for you. Named instances let you run multiple servers, and can be convenient for development and testing, but it's a feature that came out with SQL 2000, and many people aren't aware of it, so it isn't just you.
As far as I know, MSDE doesn't install the pubs database. Don't know about the inclusion of SQL Server 2000 Developer Edition with VS.NET EA, because I have an MSDN Enterprise Subscription, and have it anyway.
Main advantages;
Enterprise Manager, a wonderful GUI management tool
ISQL - a GUI SQL command builder/execution environment
Not limited to n (where n is a small number) of concurrent queries, and can use multiple CPUs if you have them.
The databases you see are created by default because they are necessary for SQL Server (or MSDE) to function. 'model' for instance is the database 'cloned' from when you create a new one.
Steve S
|
|
|
|
|
Thanks for the details Steve.
|
|
|
|
|
According to Microsoft's 'choosing' specs,
http://msdn.microsoft.com/vstudio/howtobuy/choosing.aspx
with Architect, the following should have been included:
Windows 2000 Standard Server, SQL Server 2000, Microsoft Commerce Server,
Microsoft Host Integration Server, Microsoft Exchange Server, and Microsoft
BizTalk Server.
I did not get any of this. Unfortunately, I did not buy the software directly from Microsoft, and though the Microsoft representative said I can buy SQLServer 2000 Developer Edition for about $50, he also said there is no way I can obtain the rest of the Server package from Microsoft, i.e., that my only hope for that is the cooperation of the vendor from which I purchased the software -- cooperation that has thus far been nonexistent, i.e., they are not even responding to my email.
Being new to all this, I don't know what to do. Is all the other server software so important, or is a developer edition of SQL Server 2000 likely to keep me satisfied for a long time to come? I am, after all, an extreme newbie. I only got the Architect version in the first place because I have had to deal with cheaper, inadequate tools for so long that I decided I wasn't going to go that route this time around ... (and so, of course, I didn't get the whole package; I guess I should've seen that coming).
And if the vendor (who claims to be a member of the BBB) doesn't come through, I am open to suggestions on how to get a little vengeance (if that's an appropriate topic for discussion here).
|
|
|
|
|
Well, now the vendor has replied and claims that it is his understanding that for the 2003 version of Visual Studio .Net Enterprise Architect, the server package is downloaded during the installation process. He says they have looked at another retail box and the contents are the same.
Yet when I spoke to the Microsoft rep, he seemed to indicate that I should have received the server software as I already mentioned and as seems to be indicated at (http://msdn.microsoft.com/vstudio/howtobuy/choosing.aspx).
Have I misunderstood something? Can others who purchased Architect comment as to what was and was not included?
|
|
|
|
|
Out of the box, the binaries for VS.NET 2003 Enterprise Architect (servers and all) were on the DVDs that I got, as well as a separate DVD for Visio for Enterprise Architect, prerequisites, and the VS.NET 2003 Student edition.
|
|
|
|
|
Thanks for the reply.
An exchange is now in progress which should (if all goes well) resolve the matter (I sure hope).
|
|
|
|
|
In case you or anyone following this thread is interested, I spoke to a Microsoft developer representative today who told me I do not get developer versions of the SQL Server or anything else w/ retail version of Architect, but only if I subscribe to MSDN, which I did not.
Well, IMHO, the link,
http://msdn.microsoft.com/vstudio/howtobuy/choosing.aspx
does not make this particularly clear, and admittedly the URL does begin with 'msdn' -- though one reaches this page rather easily from microsoft.com by simply clicking on a couple or three links for information about Visual Studio --
But I won't quibble.
It is funny/strange, though, that I have talked to several developers who have indicated otherwise, or at least seem to be under a differing impression.
I guess almost every developer but me can afford a subscription to MSDN ... and in fact take it for granted that all their fellow developers can ...
(sigh)
Well, I'm an MS/VS newbie after all. Maybe one of these days --
/ R
P.S. - If you think the rep got it all wrong -- and especially if you have any pull over at Microsoft -- please don't hesitate. I am frankly somewhat disappointed I didn't get the server licenses, which is at least a significant part of what I thought I was paying for.
|
|
|
|
|
the_ol_bonehead wrote:
I guess almost every developer but me can afford a subscription to MSDN ... and in fact take it for granted that all their fellow developers can ...
I doubt most developers can afford an MSDN subscription, more likely they get it through work or in my case get an academic subscription through school.
the_ol_bonehead wrote:
Well, I'm an MS/VS newbie after all. Maybe one of these days --
Hang in there, it takes a while to figure out the mysterious ways of microsoft but once you do its worth it 
Matt Newman
|
|
|
|
|
The scenario is this - a Web Service that was developed on a XP box has been deployed on IIS 6.0 & Win2k3 m/c. The Win2k3 m/c also has VS.NET 2003 installed on it.
issue #1.
The web service needs to launch a third party process (lets call it abc.exe) to work properly. This step fails on the Win2k3 box. w3wp.exe is running under the default NETWORK SERVICE user privileges. Is there a way to enable/set privileges to the NETWORK SERVICE account so that the ASP.NET worker process has the ability to launch any/specific process? [i tried launching Notepad.exe thru the web service & it seems to launch this successfully.]
issue #2
i expected to debug the web service on the Win2k3 m/c via VS.NET but it fails with the message "... Unable to start debugging on web server. The project not configured to be debugged.". I verified the project settings between my XP & Win2k3 m/c & they are identical. Now i'm beginning to suspect that the Win2k3 default lock-down security is the culprit. Any pointers? I even added the user to the "Debugger Users" group as suggested in the docs to no avail.
Any help is appreciated. TIA.
Chen Venkataraman
|
|
|
|
|
This is ramakrishna from INDIA. i have a doubt on IE5.0 and above
with MAC Operating System.
i have developed an application in .NET using
Asp.NET,VB.NET,Javascript and Flash. This application is working
file windows operating systems. I dont have any idea on MAC with
I.E.5.0 and above so what are the problems we may expect when we
access the .NET application through MAC OS with I.E.5.0 and above.
plz reply me....
Thanks
Ramakrishna.J
SoftProSystems ltd.
|
|
|
|
|
If you develop a Web Application on ASP.NET, you don't have to access directly to the client file system, unless your client upload files or similar. So it's no problem I think.
----
hxxbin
|
|
|
|
|
Hi,
I planned to buy a laptop... and suddenly I was thinkin about the 'CREATIVE sound Cards'.. will it be posible to put my laptop with creative soundcards??
Please help
I was born intelligent
Education ruined me!.
|
|
|
|
|
One solution is to use an external Creative SoundBlaster. The low end one is pretty good, and has optical in/out (TOSlink) as well as RCA line in/out, and 3.5mm headphone and microphone sockets. The headphone has a separate physical volume control.
The whole thing is in a small box you just connect to a USB port (don't go through a hub unless it's powered), and works a treat.
Steve S
(No, I don't work for Creative, I just have an external SB and love it!)
|
|
|
|
|
thanks. Will check that out 
I was born intelligent
Education ruined me!.
|
|
|
|
|
I'm hosting a site on IIS, but when I try to access it
from the internet I get a sign-in box, and then Error:
Access is Denied message. If I fill out a valid username
and password I can access the web site. But I want users to
access my site without a password.
I've enabled anonymous access to the website, and I've
given the IUSR_machinename account Read, Read & Execute, and List Folder Contents NTFS permissions to the
physical folder where the site is located.
What else do I have to do to allow anonymous visitors to
my site?
Thanks
|
|
|
|
|
It sounds as if you've done everything right, but double check - did you select the box to allow permissions to be inherited from the site folder? You may also have to grant IUSR permissions on individual files, if they were added before you enabled access to the folder; permissions are assigned at the time of file creation, and as far as I know, they are not periodically reviewed. Also, although it shouldn't be necessary, I find that it helps after making such changes to restart IIS.
Heard in Bullhead City - "You haven't lost your girl -
you've just lost your turn..." [sigh] So true...
|
|
|
|
|
Is windows authentication still checked? I have found that often times Windows Authentication stays cheched and causes the problem. If your not sure what I am talking about I can take a screenshot for you, just let me know if you need me to.
Matt Newman
|
|
|
|
|
I'm hosting a site on IIS, but when I try to access it
from the internet I get a sign-in box, and then Error:
Access is Denied message. If I fill out a valid username
and password I can access the web site. But I want users to
access my site without a password.
I've enabled anonymous access to the website, and I've
given the IUSR_machinename account Read, Read & Execute, and List Folder Contents NTFS permissions to the
physical folder where the site is located.
What else do I have to do to allow anonymous visitors to
my site?
Thanks
|
|
|
|
|
Hi ,
I am currently prgramming a moderately large solution. Many projects have many dependancies with other projects within the same solution. When I try to compile it, VS.NET gives me an error saying it cannot copy certain (compiled) class libraries into the same directory. It says it is because there are already copies of the dlls in the output directory already.
Right now I have merely told the VS not to copy certain dlls locally. This works fine for debug compilations. But often the release compilations tend to crash half way through because it cannot find the specified versions of specific files (dlls).
Please help me Out.....
ZT
ZT
|
|
|
|
|
Hello,
I have a windows 2000 server in my network and I need databases. Does SQL server 7 run properly on windows 2000, or do I need SQL server 2000?
Thanks.
A student knows little about a lot.
A professor knows a lot about little.
I know everything about nothing.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
