Installing Sql Server and Visual Basic .NET

Browsing the Sql server installation cd I found that I need to create a
domain name. What will be the difference with WORKGROUP network? Do I need to
change from workgroup to domain name?> Browsing the Sql server installation cd I found that I need to create a
> domain name.
? Could you be more specific? Where did you "find" this?|||Urraca wrote:
> Browsing the Sql server installation cd I found that I need to create
> a domain name. What will be the difference with WORKGROUP network? Do
> I need to change from workgroup to domain name?
No. A workgroup is fine for SQL Server installation.
--
David Gugick
Imceda Software
www.imceda.com|||You may want to search for "Authentication Modes" in BOL for a
discussion of how authentication can be configured in SQL Server.
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Wed, 4 May 2005 09:10:10 -0700, Urraca
<chiriqui9844(removethis)@.msn.com> wrote:
>Browsing the Sql server installation cd I found that I need to create a
>domain name. What will be the difference with WORKGROUP network? Do I need to
>change from workgroup to domain name?

Installing Sql Server and Visual Basic .NET

Browsing the Sql server installation cd I found that I need to create a
domain name. What will be the difference with WORKGROUP network? Do I need to
change from workgroup to domain name?
> Browsing the Sql server installation cd I found that I need to create a
> domain name.
? Could you be more specific? Where did you "find" this?
|||Urraca wrote:
> Browsing the Sql server installation cd I found that I need to create
> a domain name. What will be the difference with WORKGROUP network? Do
> I need to change from workgroup to domain name?
No. A workgroup is fine for SQL Server installation.
David Gugick
Imceda Software
www.imceda.com
|||You may want to search for "Authentication Modes" in BOL for a
discussion of how authentication can be configured in SQL Server.
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg...l/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Wed, 4 May 2005 09:10:10 -0700, Urraca
<chiriqui9844(removethis)@.msn.com> wrote:

>Browsing the Sql server installation cd I found that I need to create a
>domain name. What will be the difference with WORKGROUP network? Do I need to
>change from workgroup to domain name?

Installing Sql Server and Visual Basic .NET

Browsing the Sql server installation cd I found that I need to create a
domain name. What will be the difference with WORKGROUP network? Do I need t
o
change from workgroup to domain name?> Browsing the Sql server installation cd I found that I need to create a
> domain name.
? Could you be more specific? Where did you "find" this?|||Urraca wrote:
> Browsing the Sql server installation cd I found that I need to create
> a domain name. What will be the difference with WORKGROUP network? Do
> I need to change from workgroup to domain name?
No. A workgroup is fine for SQL Server installation.
David Gugick
Imceda Software
www.imceda.com|||You may want to search for "Authentication Modes" in BOL for a
discussion of how authentication can be configured in SQL Server.
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Wed, 4 May 2005 09:10:10 -0700, Urraca
<chiriqui9844(removethis)@.msn.com> wrote:

>Browsing the Sql server installation cd I found that I need to create a
>domain name. What will be the difference with WORKGROUP network? Do I need
to
>change from workgroup to domain name?sql

Integrated Security in a Workgroup?

The A\ASPNET and B\ASPNET machine accounts are created by IIS (I think) --
at least I know that I did NOT create them. These are the accounts used by
IIS when executing ASP pages. Since these accounts are not created by me I
don't know the passwords -- and I can't just change them in XP because then
IIS will likely fail due to using the old password. Perhaps I can change
the default ASP account used by IIS on both machines -- then I can create
local accounts with the same username and password.
Thanks for the suggestion.
Bill
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:uOFYrdRuDHA.3144@.tk2msftngp13.phx.gbl...

quote:

---

> I believe that you do this without specifying the A\ or B\.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

> Please reply to the newsgroups only, thanks.
> "Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
> news:#aPrRKOuDHA.4056@.TK2MSFTNGP11.phx.gbl...
> A\ASPNET
the[QUOTE]
> A
and[QUOTE]
> an
only.[QUOTE]
the[QUOTE]
> SQL
> rights.
>

---

Kevin
Thanks for the response. Please see my reply to dybing regarding
passwords being problematic.
Bill
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:uN4DrXRuDHA.1360@.cpmsftngxa06.phx.gbl...

quote:

---

> See if you can make a Trusted Connection using SQL. If the passwords are
> the same, then this should work.
> Use ISQL.exe
> ISQL -SSQLServerNameHere -E -Q"select @.@.version"
> This should return the version of SQL 2000.
> If this works then, we know the security is working, it may be a
> configuration issue with ASP.NET.
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

---

|||No, sorry, what I meant was that when you set up the SQL Server permissions,
try it without including the A\ or B\.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:utxj$XduDHA.1596@.TK2MSFTNGP10.phx.gbl...

quote:

---

> The A\ASPNET and B\ASPNET machine accounts are created by IIS (I think) --
> at least I know that I did NOT create them. These are the accounts used by
> IIS when executing ASP pages. Since these accounts are not created by me I
> don't know the passwords -- and I can't just change them in XP because

---

then

quote:

---

> IIS will likely fail due to using the old password. Perhaps I can change
> the default ASP account used by IIS on both machines -- then I can create
> local accounts with the same username and password.
> Thanks for the suggestion.
> Bill
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:uOFYrdRuDHA.3144@.tk2msftngp13.phx.gbl...
> rights.
> the
> and
> only.
> the
the[QUOTE]
>

---

|||Since I'm using integrated security I must select an existing NT user; thus
I can't specify a user, ASPNET (or whatever), unless that user exists as a
local user on the machine. I can of course create such a user, but then I've
got the password problem I already mentioned. Have I misunderstood your
suggestion?
Bill
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23nPgnyduDHA.2148@.TK2MSFTNGP12.phx.gbl...

quote:

---

> No, sorry, what I meant was that when you set up the SQL Server

---

permissions,

quote:

---

> try it without including the A\ or B\.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

> Please reply to the newsgroups only, thanks.
> "Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
> news:utxj$XduDHA.1596@.TK2MSFTNGP10.phx.gbl...
think) --[QUOTE]
by[QUOTE]
I[QUOTE]
> then
change[QUOTE]
create[QUOTE]
that[QUOTE]
B[QUOTE]
message[QUOTE]
duplicate[QUOTE]
> the
>

---

|||Hmm, I had assumed, like Kevin mentioned earlier, that if you used those
workgroup users, where the only thing that changed was the name of the
workgroup, it would work. I've done similar sorts of things with accounts
crossing different domains before and figured this would work as well. If
not, then your problem is beyond what I can help with off the top of my
head, and I don't have workgroup machines here that I can test on. Sorry!
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:eXwPQHeuDHA.1888@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Since I'm using integrated security I must select an existing NT user;

---

thus

quote:

---

> I can't specify a user, ASPNET (or whatever), unless that user exists as a
> local user on the machine. I can of course create such a user, but then

---

I've

quote:

---

> got the password problem I already mentioned. Have I misunderstood your
> suggestion?
> Bill
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23nPgnyduDHA.2148@.TK2MSFTNGP12.phx.gbl...
> permissions,
> rights.
> think) --
used[QUOTE]
> by
me[QUOTE]
> I
> change
> create
> that
machine[QUOTE]
> B
purposes[QUOTE]
> message
> duplicate
on[QUOTE]
no[QUOTE]
>

---

|||Please let me know if you're still having a problem with this and I'll
request a couple of workgroup machines from our lab this week and try it
myself. You can reach me directly by removing the "online." from my posting
address.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:eXwPQHeuDHA.1888@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Since I'm using integrated security I must select an existing NT user;

---

thus

quote:

---

> I can't specify a user, ASPNET (or whatever), unless that user exists as a
> local user on the machine. I can of course create such a user, but then

---

I've

quote:

---

> got the password problem I already mentioned. Have I misunderstood your
> suggestion?
> Bill
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23nPgnyduDHA.2148@.TK2MSFTNGP12.phx.gbl...
> permissions,
> rights.
> think) --
used[QUOTE]
> by
me[QUOTE]
> I
> change
> create
> that
machine[QUOTE]
> B
purposes[QUOTE]
> message
> duplicate
on[QUOTE]
no[QUOTE]
>

---

|||OK, I think I've got it working. I discovered (via KB #315158) how to
set the account and password used by IIS via attributes in the
processModel element of the machine.config file. All I needed to do was
1.) Reset the password of the <machine>\ASPNET account to a common value
on both machines.
2.) Edit the machine.config file on both machines to reflect the new
common password.
I'd already added the ASPNET account as a login on the SQL server. Since
now the A\ASPNET and B\ASPNET have common login names AND passwords I
can apparently access the SQL server on machine B via the A\ASPNET
account on machine A. This solves my problem.
Bill
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:eXwPQHeuDHA.1888@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Since I'm using integrated security I must select an existing NT user;

---

thus

quote:

---

> I can't specify a user, ASPNET (or whatever), unless that user exists as a
> local user on the machine. I can of course create such a user, but then

---

I've

quote:

---

> got the password problem I already mentioned. Have I misunderstood your
> suggestion?
> Bill
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23nPgnyduDHA.2148@.TK2MSFTNGP12.phx.gbl...
> permissions,
> rights.
> think) --
used[QUOTE]
> by
me[QUOTE]
> I
> change
> create
> that
machine[QUOTE]
> B
purposes[QUOTE]
> message
> duplicate
on[QUOTE]
no[QUOTE]
>

---

Installing SQL 7 SP4 is a Domain are domain accounts required

When installing SQL 7 (non clustered) on a server is it neccessary to use
domain accounts.
e.g. We have a web server that is part of the workgroup "workgroup" this web
server is to access via the application on it the SQL database that resides
on a separate server (also in "workgroup") is it neccessary to create a
domain and have both these servers as members?
Thank youThere is no domain account for a workgroup topology. You will want to use
sql login for your authentication.
-oj
http://www.rac4sql.net
"Bruce Gilbert" <bruce.gilbert@.cgi.com> wrote in message
news:%23GsIqzCDEHA.2424@.TK2MSFTNGP09.phx.gbl...
> When installing SQL 7 (non clustered) on a server is it neccessary to use
> domain accounts.
> e.g. We have a web server that is part of the workgroup "workgroup" this
web
> server is to access via the application on it the SQL database that
resides
> on a separate server (also in "workgroup") is it neccessary to create a
> domain and have both these servers as members?
> Thank you
>|||To answer you question specifically. You do not need a domain. However, all
connectivity to the SQL Server machine will either have to be done with SQL
authentication or passthrough authentication (the same NT user and password
on both the client and SQL Server machine)
Rand
This posting is provided "as is" with no warranties and confers no rights.

Installing SQL 2005 Workgroup failing

I am trying to install SQL 2005 WorkGroup on a machine that falls within the hardware specs, but the installer says that it dosn't make it..

Hardware

Celeron 1g with 760m ram, installing on SBS Standard 2003 SP1.

Anyone have any ideas how to move forward.

Hi,

try to look in

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

to see what error occured during the install process.

HTH, jens Suessmeyer.

|||

Glenn,

Go ahead and file a bug with http://lab.msdn.microsoft.com/productfeedback/ and include the log files from %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\Log\Files. Also include all relevant information about your hardware and what OS you are installing on. I'll look at the log files and get back to you.

-Jeffrey