MS Sqlserver 2005: Displaying only dbs user has a right to?

Hi;

My company just installed MS SQLServer 2005 ( see below the dotted
line ).

When a user logs into management studio all of the databases on the
server are displayed in the right hand column.

What can we do to have only the databases the user has rights to,
display?

Thanks much in advance for any info.

Steve

--------------------
Microsoft SQL Server Management Studio9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML2.6 3.0 4.0 6.0
Microsoft Internet Explorer7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System5.1.2600Steve (tinker123@.gmail.com) writes:

Quote:

Originally Posted by

My company just installed MS SQLServer 2005 ( see below the dotted
line ).
>
When a user logs into management studio all of the databases on the
server are displayed in the right hand column.
>
What can we do to have only the databases the user has rights to,
display?

What you can do is to revoke the permission VIEW ANY DATABASE from public,
or DENY this permission to the users in question. Alas, the user would then only see tempdb and msdb (or was it master?), databases he owns, and
possibly his current database. He would have to issue a USE database in
the dark to get there.

This is not an uncommon question, so I filed a suggestion for an improvement
in SQL Server. You can vote on it at
https://connect.microsoft.com/SQLSe...edbackID=273830
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

MS SQL2005 reporting Services + AD. Security question

Hi we run completely Windows shop. So Windows Authentication for Reporting Services is only acceptable solution. Idea is that I assign user in RS manager but they get their security check through AD using Cerberus or whatever it is. We did this setup for intranet web site which consist three machine

PC#1 Domain controller (AD)

PC#2 IIS (intranet web site)

PC#3 MS SQL server. (data)

People logon on web server newer asked for credentials on pull up data from SQL server though IIS being themselves, impersonation.

Now I have setup

PC#1 SSRS, IIS for Reports Server, MS SQL 2k5 for RS metadata etc

PC#2 Domain controller (AD)

PC#3 MS SQL2k (data)

I did same setspn procedure but when I tried to log on Report server it asked me for credentials. Moreover when I provide my logon and password it denies it, accepting only admin credentials.

I went trough few books, number article but nobody describe this scenario in spite it should be most popular solution if network based on Windows.

Any help is really appreciated

I am a way out of my league here, but I don't think it is the Report Server who prompts for credentials but IIS. If you create a web app in IIS configured for Windows authentiction and drop a simple html file in it, i bet you will be prompted for when you try to browse it. As far as what's causing it (excluding configuration issues), you may find the following article useful.|||

Teo,

Thanks a lot. I should read this article monthes ago. It is simple and nice compilation about delegation. I will try my luck with tweaking Report Server config and SPN.

I'll keep posting how I am doing, I think it will be helpfull for everybody who will decide to implement SSRS2k5 similar way

MS Sql Server User ID, Password and connection string

Hi;
I am making a software (.Net) which is going to connect a ms sql server but I cant conect yet :(.

1- I dont know what I have to type for user id (name)
2- What is my password, it has been long time that I hvae installed it but I dont need any password with Microsoft SQL Server Management Studio Express which has windows authentication option. My software can work via internet or network. So I need to know my user name and password. I am using oledbconnection. Do I need any password?
3- I visited www.connectionstrings.com already so I have the format of it.

Thanks very much for any help...you need to either use your windows account and use the example from connection strings dot com that uses windows auth or you need to go to SQL Server management studio to create a sql server login and password and you will need to give that account access to the specific database you are accessing.

man do the redskins suck.

ms sql server response is slow

Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgs
You have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs
|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:

> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO libraries
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exactly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers down
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
>
>
sql

ms sql server response is slow

Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on Windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgsYou have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on Windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:

> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO librari
es
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exact
ly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers do
wn
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
>
>

ms sql server response is slow

Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgsYou have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:
> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO libraries
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exactly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers down
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> > Hi ,
> >
> > i have ms access client program connecting to sql server 2000 wif sp3a
> > running on windows 2000 server
> >
> > the user is complaining that the response from the client program is slow
> >
> > i have check the current activity and there's no much user connected and
> > there's no lock/blocking process
> >
> > where could i check further to determine the cause ?
> >
> > tks & rdgs
>
>

MS SQL server handling unicode data

Hi,

I want to fetch Unicode data from MS SQL server 2005.I have created one user with russian language characters.

Following is my code snippet:
-----------
wchar_t wchar1[55];
char VALUE[255];

while (rc != SQL_NO_DATA)
{
rc = SQLFetch(hstmt);
if (rc != SQL_NO_DATA)
memset(VALUE,0,255);
int length=wcstombs( NULL,(wchar_t *)&wchar1, wcslen(wchar1));
char* strChar = (char *) malloc((length +1 )* sizeof(char));
if (strChar != NULL)
{
count++;
memset(strChar,0, length + 1 );
int i =wcstombs(strChar, wchar1, wcslen(wchar1) );
printf( "i is %d\n",i);
}
printf( "The length is %d\n",length);
wprintf(L"\n <%s>", wchar1);
printf("\n simple char <%s>", strChar);
wprintf(L"\n simple char <%S>", wchar1);
}


-----------

CAn anybody help me ?
I think problem is in fetching of name.
Does anybody have working code for fetching unicode data from SQL server 2005.

Also I want query that will tell the locale setting of the server and also client?

Thanks--the sql server datatypes nchar/nvarchar/ntext are for unicode strings.

if you are using char/varchar/text in your columns, they won't be unicode.|||I know that nchar,nvarchar dayta types are unicode datatypes.
But C compiler is not able to resolve them.
It gives me error unkhown identifier.
Do u know which header files to be added for datatype nchar?
If you have any program for fetching unicode data,Please can you sned to me.
Its urgent.:eek:
I will be very thankful to you...|||Use the T-SQL COLLATE function and supply the corresponding collation for Russian.|||My problem is different.Actaully i want to support internationalization in my product which means product should support all the languages.
My product is for user and password management for MS SQL server 2005.
I want to fetch userdata in all languages.Not only in English(ANSI)
SO every time i will niether be aware of the collation setting of the database nor the locale setting when user is created.(language in which user has been created)
So in this situation I need generalise solution.
for example:
--------------
In Oracle using OCCI,we can set environment to OCCIUTF8.
Code for this is
Environment *env = Environment::createEnvironment(OCCIUTF8,OCCIUTF 8);
{
Connection *conn = env->createConnection(userName, password,
connectString);

This will work irrespective of NLS setting of server.

--------------

IN the same way is there any environmenet setting which needs to be done for supporting internationalisation?

I hope this will explain you all my realy problem.
Please help me....
I am using ODBC API for this.
If possible if anybody is having working code in c .........;)
that will be very helpful

waiting for your help...

Regards
Sam

MS SQL Server 2000 - Run query as a different user

Can we run some query as a different user working with MS SQL Server 2000?
For example if we connected to the DB in the Enterprise Manager as User1,
can we run some query as User2?
We need to select from a VIEW pulling data from some DB, we can encrypt the
text of this view hiding the target tales and their structure on the target
DB. But since the view works with this DB it should have the permissions to
SELECT from this DB, and that gives the green light to the user to see these
tables in the Enterprise Manager.
It would be nice if we could run the queries inside the view under another
user account and then encrypt the view so that the user will see the view as
it works but should never see the DB tables or the text of the view.
Just D.Of course you can do that, this is one of the benefits of the views.
Example:
Make dbo owner of table employees
Create a view owned by dbo to access some of the fields of employee table
Give permissions to user1 to this view
User1 will be able to access the view but not the employees table
Ben Nevarez, MCDBA, OCP
Database Administrator
"Dmitri Shvetsov" wrote:

> Can we run some query as a different user working with MS SQL Server 2000?
> For example if we connected to the DB in the Enterprise Manager as User1,
> can we run some query as User2?
> We need to select from a VIEW pulling data from some DB, we can encrypt th
e
> text of this view hiding the target tales and their structure on the targe
t
> DB. But since the view works with this DB it should have the permissions t
o
> SELECT from this DB, and that gives the green light to the user to see the
se
> tables in the Enterprise Manager.
> It would be nice if we could run the queries inside the view under another
> user account and then encrypt the view so that the user will see the view
as
> it works but should never see the DB tables or the text of the view.
> Just D.
>
>

MS SQL Server - User Rights

Does anyone know if it possible to make a specific table invisible to a
user when they are in Enterprise Manager?Hi

This would not be possible as you are denying them access to the system
catalogs. If you profiled EM you would see the statement used, and if they
had QA they could always run this sort of query themselves. Just because you
see table does not mean they can see the structure or contents.

John
"code2live" <akorol@.gmail.com> wrote in message
news:1109889106.584853.170100@.f14g2000cwb.googlegr oups.com...
> Does anyone know if it possible to make a specific table invisible to a
> user when they are in Enterprise Manager?

MS SQL passing in more than 8000 characters

if a user chooses to request a lot of customers to report on say from a multi select listbox - what is the best way to pass this list to my stored proc? Looking for suggestions.

thanks,

Can you post some more details of what you want to do and how you have you are trying to achieve it right now? From the question you've posted it looks like you want to send so much details to your sproc.

|||

hi,

you can use the ntext as a datatype for storing huge values in the sql server 2005.

The value changes dynamically ,so we can use

sqlcmd.paramters.add("paramter Name").value= @.value

By using the above syntax we can give input whatever the value is. but do remeber make the datatype of the field as ntext.

cheeers mate...

VIjay

|||

i apologize for being to vague, it's a sql 2000 db and if all options were selected and thrown into a column the field would exceed the 8000 characters, this has to be saved so the user could re-run the same row if they choose to, so as the users build these requests - they are saved to a db, now maybe i could write the selected lists to an xml file and then pass that into my stored proc paramaters, but i've never done anything like that, possibly save the xml file with a relation to the row and then when the users calls that tracking again - it knows to grab that xml file and feed it to the stored proc? possibly you have seen or done this before.

thanks,

Jeff

ms sql mdf database file attached vs created on sql server

Hi all

I have a question concerning sql database mdf files. In the old days I would user a ms access database. This file would be stored with the actual web files and would utilise a dsn connection.

I have noted when designing with vwd 2005 express it allows you to use 2 methods of creating a mdf database. You can either create it as an attachment mdf or you can create it directly using sql manager.

My question is, if you create the mdf database as an attachement file can you store it in the same manner as if you where using a ms access database, meaning can you store it with the web site's files so it uses the file storage allocated size and then create a connection similar to a dsn (but for sql) to the isp's sql engine or does it have to be uploaded to the isp' s sql server.

The reason for this question is some of my customers do not want to pay the extra cost to have an sql allocation, however I do not want to go back to using old asp methods to create advanced sites as I prefer using stored procedures.

Any help will be appreciated

Hi,

you can attach your .mdf file (SQL Server Express) to a database (Attaching a .mdf file when you don't have the .ldf file available). However I think the hosting company will charge your customers for attaching it. To my knowledge you don't have a replacement available like DSN.

Grz, Kris.

|||

Hi there,

My first website I did using Visual Studio I used an sql express database. Most hosting companys only use SQL server so you'll have to do some changes to your express database to get it hosted. So it doesnt really matter which way you design your database.

The hosting company will usually place your database on a separate secure server where you'll be able to access through SQL Server Manager once you have a static IP address. I'm not sure which hosting company you use but I live in Ireland and the best company here for windows hosting iswww.blacknight.ie

I use the standard windows hosting which allows you have up to 16 websites and 16 SQL server databases. An excellent company.

I recommend if you are going to use this a lot, upgrade your package to Visual Studio pro and this includes SQL Server Developer edition which allows you to create a SQL Server 2005 database which makes it easier when you go to publish your application.

Hope this is some use to you.

Anthony

|||

Hi Kris

So what you are saying is you can attach a database to an sql server without having to import it directly. Which means the database can run externally from the sql server. My hosting company I think offers it for free if you are attaching and they have a control panel which makes it user friendly to do this by yourself. I will contact them again to verify. www.sahost.co.za

|||

Hi,

about 1,5 years ago I tried out a free hosting for ASP.NET 2.0 where you could upload a .mdf file to and in their admin pages they provided such an attach procedure. Unfortunately I don't remember their name.

Grz, Kris.

ms sql equivalent of this oracle

Hi.
I'm a casual sql user. I have found a situation where I need to convert an
oracle statement to tsql, one I can just fire off in any sql tool against an
ms sql server database.

I studied the exists statement and I think I understand it somewhat, however I
was not sure how to get it quite right. If you have an idea and a minute or
two I'd appreciate any insight or tutorial.

insert into authorization (program, optiontitle, usergroup, authorizationid)
select 'EVERYWHERE','NAVIGATOR',usergroup, authorizationseq.nextval
from allgroups where exists (select * from authorization
where authorization.USERGROUP = allgroups.USERGROUP and
authorization.optiontitle = 'READ' and authorization.program = 'EVERYWHERE')

I believe that because in my data, three values of usergroup from allgroups
return true from the exists, that this is supposed to insert three rows into
authorization.

But I can't figure out what to do about the authorization.nextval.. I tried
various max(authorization)+1
etc but nothing seemed to compile/work

thanks
Jeff KishHi

You can make the column an identity, this will not guarantee contiguous
number but it will be increasing/decreasing and unique. You can then miss it
out from the statement altogether.

These may help:
http://vyaskn.tripod.com/oracle_sql...equivalents.htm
http://www.microsoft.com/technet/pr...art2/c0761.mspx

John

"Jeff Kish" <jeff.kish@.mro.com> wrote in message
news:b5a7u1lod76n3at35csf2b6f8nvpj35jn8@.4ax.com...
> Hi.
> I'm a casual sql user. I have found a situation where I need to convert an
> oracle statement to tsql, one I can just fire off in any sql tool against
> an
> ms sql server database.
> I studied the exists statement and I think I understand it somewhat,
> however I
> was not sure how to get it quite right. If you have an idea and a minute
> or
> two I'd appreciate any insight or tutorial.
> insert into authorization (program, optiontitle, usergroup,
> authorizationid)
> select 'EVERYWHERE','NAVIGATOR',usergroup, authorizationseq.nextval
> from allgroups where exists (select * from authorization
> where authorization.USERGROUP = allgroups.USERGROUP and
> authorization.optiontitle = 'READ' and authorization.program =
> 'EVERYWHERE')
>
> I believe that because in my data, three values of usergroup from
> allgroups
> return true from the exists, that this is supposed to insert three rows
> into
> authorization.
> But I can't figure out what to do about the authorization.nextval.. I
> tried
> various max(authorization)+1
> etc but nothing seemed to compile/work
> thanks
> Jeff Kish|||Jeff,

authorizationseq seems to be a sequence. Sequences just don't exist in
MS SQL Server 2000/7/6.5. You might want to have an identity column.|||On Sat, 4 Feb 2006 16:17:55 -0000, "John Bell" <jbellnewsposts@.hotmail.com>
wrote:

>Hi
>You can make the column an identity, this will not guarantee contiguous
>number but it will be increasing/decreasing and unique. You can then miss it
>out from the statement altogether.
>These may help:
>http://vyaskn.tripod.com/oracle_sql...equivalents.htm
>http://www.microsoft.com/technet/pr...art2/c0761.mspx
thanks. I'm still not sure of how to do something here, though.

This is directly related to the problem but re-worded because I need to
get the next value using max(authorizationid)+1 ...

Given two tables:
allgroups(usergroup, otherdata) =
{'group1',otherdata1,
'group2',otherdata2,
'group3',otherdata3,
:
:
'groupn',otherdatan}

and
authorization(program,optiontitle,
usergroup,authorizationid) =
{'pro1','title1','ug1',3,
'pro2','title2','ug2',4,
:
'pron','titlen','ugn',m}

How can I insert multiple
lines (one for each usergroup
in allgroups) using one sql statement
into authorization if this is correct for a
single insert:
insert into authorization(program,
optiontitle,usergroup,
authorizationid)
select 'proq','titleq','ug1',
max(authorizationid)+1
from authorization

bascially I'd like each usergroup
from allgroups to be used to create a
new line in authorization, having
the authorizationid increment one from
the current max.

Yes, I have no control over the design/use of
an identity column.

Is it possible?
Thanks
Jeff Kish|||Jeff Kish wrote:

> thanks. I'm still not sure of how to do something here, though.
> This is directly related to the problem but re-worded because I need to
> get the next value using max(authorizationid)+1 ...
> Given two tables:
> allgroups(usergroup, otherdata) =
> {'group1',otherdata1,
> 'group2',otherdata2,
> 'group3',otherdata3,
> :
> :
> 'groupn',otherdatan}
> and
> authorization(program,optiontitle,
> usergroup,authorizationid) =
> {'pro1','title1','ug1',3,
> 'pro2','title2','ug2',4,
> :
> 'pron','titlen','ugn',m}
> How can I insert multiple
> lines (one for each usergroup
> in allgroups) using one sql statement
> into authorization if this is correct for a
> single insert:
> insert into authorization(program,
> optiontitle,usergroup,
> authorizationid)
> select 'proq','titleq','ug1',
> max(authorizationid)+1
> from authorization
> bascially I'd like each usergroup
> from allgroups to be used to create a
> new line in authorization, having
> the authorizationid increment one from
> the current max.
> Yes, I have no control over the design/use of
> an identity column.
> Is it possible?
> Thanks
> Jeff Kish

Assuming SQL Server 2005 (you didn't specify otherwise), use the
ROW_NUMBER function. For example:

INSERT INTO [authorization]
(program, optiontitle, usergroup, authorizationid)
SELECT program, optiontitle, usergroup,
authorizationid+
(SELECT MAX(authorizationid)
FROM [authorization])
FROM
(SELECT 'proq','titleq', usergroup, ROW_NUMBER()
OVER (ORDER BY usergroup)
FROM allgroups)
AS T(program, optiontitle, usergroup, authorizationid) ;

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--|||<snip>
>Assuming SQL Server 2005 (you didn't specify otherwise), use the
Sql Server 2000. Really sorry I did not say it up front. Do you know
of a way using that?
Regards,
Jeff

>ROW_NUMBER function. For example:
>INSERT INTO [authorization]
> (program, optiontitle, usergroup, authorizationid)
> SELECT program, optiontitle, usergroup,
> authorizationid+
> (SELECT MAX(authorizationid)
> FROM [authorization])
> FROM
> (SELECT 'proq','titleq', usergroup, ROW_NUMBER()
> OVER (ORDER BY usergroup)
> FROM allgroups)
> AS T(program, optiontitle, usergroup, authorizationid) ;
>--
>David Portas, SQL Server MVP
>Whenever possible please post enough code to reproduce your problem.
>Including CREATE TABLE and INSERT statements usually helps.
>State what version of SQL Server you are using and specify the content
>of any error messages.
>SQL Server Books Online:
>http://msdn2.microsoft.com/library/...US,SQL.90).aspx|||Jeff Kish wrote:
> <snip>
> >Assuming SQL Server 2005 (you didn't specify otherwise), use the
> Sql Server 2000. Really sorry I did not say it up front. Do you know
> of a way using that?
> Regards,
> Jeff

INSERT INTO [authorization]
(program, optiontitle, usergroup, authorizationid)
SELECT program, optiontitle, usergroup,
authorizationid+
(SELECT COALESCE(MAX(authorizationid),0)
FROM [authorization])
FROM
(SELECT 'proq','titleq', A1.usergroup, COUNT(*)
FROM allgroups AS A1
JOIN allgroups AS A2
ON A1.usergroup >= A2.usergroup
GROUP BY A1.usergroup)
AS T(program, optiontitle, usergroup, authorizationid) ;

This assumes that usergroup is unique in Allgroups. If I'm wrong then
use the key of that table in the join. You need a key in order to
generate the sequence.

Read my signature. It may help you get faster answers in future.

Hope this helps.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--

MS SQL compare columns to generate display name

Hello, I have the following table with 4 columns...

firstname, lastname1, lastname2, EMAIL

Table has user names and email, I would like to generate a 5th column
called DisplayName.
The email Id is sometimes firstname.lastname1.lastname2@. and others
just firstname.lastname1@.

I would like to generate the display name exactly like the email eg
firstname.lastname1.lastname2@. displayName = firstname lastname1
lastname2.....so for james.smith display name = James Smith and for
james.earl.smith displayName = James Earl Smith etc etc

Is there a way that I can check/compare email Id (before the @. part)
with firstname, lastname1 and lastname2 and generate a display name
based on what was used for the email address?

I hope I've explained this well :-)

Many thanks in advance for any help/advise

YasOn 17 Sep, 13:32, Yas <yas...@.gmail.comwrote:

Quote:

Originally Posted by

Hello, I have the following table with 4 columns...
>
firstname, lastname1, lastname2, EMAIL
>
Table has user names and email, I would like to generate a 5th column
called DisplayName.
The email Id is sometimes firstname.lastname1.lastname2@. and others
just firstname.lastname1@.
>
I would like to generate the display name exactly like the email eg
firstname.lastname1.lastname2@. displayName = firstname lastname1
lastname2.....so for james.smith display name = James Smith and for
james.earl.smith displayName = James Earl Smith etc etc
>
Is there a way that I can check/compare email Id (before the @. part)
with firstname, lastname1 and lastname2 and generate a display name
based on what was used for the email address?

By the way is this even possible in MS SQL? :-)

Cheers
Yas|||Something is probably possible. Transact-SQL has very basic string
manipulation capability, and the CASE expression allows resolving to
different values depending on testable conditions. If you posted
CREATE TABLE and INSERTs for a variety of test data, along with
expected output, you might get a more specific response.

How confident are you that the email name matches the name in the
three name columns?

Roy Harvey
Beacon Falls, CT

On Mon, 17 Sep 2007 12:53:15 -0700, Yas <yasar1@.gmail.comwrote:

Quote:

Originally Posted by

>On 17 Sep, 13:32, Yas <yas...@.gmail.comwrote:

Quote:

Originally Posted by

>Hello, I have the following table with 4 columns...
>>
>firstname, lastname1, lastname2, EMAIL
>>
>Table has user names and email, I would like to generate a 5th column
>called DisplayName.
>The email Id is sometimes firstname.lastname1.lastname2@. and others
>just firstname.lastname1@.
>>
>I would like to generate the display name exactly like the email eg
>firstname.lastname1.lastname2@. displayName = firstname lastname1
>lastname2.....so for james.smith display name = James Smith and for
>james.earl.smith displayName = James Earl Smith etc etc
>>
>Is there a way that I can check/compare email Id (before the @. part)
>with firstname, lastname1 and lastname2 and generate a display name
>based on what was used for the email address?

>
>
>By the way is this even possible in MS SQL? :-)
>
>Cheers
>Yas

|||Yas (yasar1@.gmail.com) writes:

Quote:

Originally Posted by

firstname, lastname1, lastname2, EMAIL
>
Table has user names and email, I would like to generate a 5th column
called DisplayName.
The email Id is sometimes firstname.lastname1.lastname2@. and others
just firstname.lastname1@.
>
I would like to generate the display name exactly like the email eg
firstname.lastname1.lastname2@. displayName = firstname lastname1
lastname2.....so for james.smith display name = James Smith and for
james.earl.smith displayName = James Earl Smith etc etc
>
Is there a way that I can check/compare email Id (before the @. part)
with firstname, lastname1 and lastname2 and generate a display name
based on what was used for the email address?
>
I hope I've explained this well :-)

UPDATE tbl
SET DisplayName = CASE substring(lower(email),
1, charindex('@.', email) - 1)
WHEN lower(firstname) + '.' + lower(lastname)
THEN firstname + ' ' + lastname
WHEN lower(firstname) + '.' + lower(lastname) +
'.' + lower(lastname2)
THEN firstname + ' ' + lastname + ' '
lastname2
END
WHERE DisplayName IS NULL

I have here assumed that firstname, lastname and lastname2 are entered
with proper case.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On 17 Sep, 23:18, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

Yas (yas...@.gmail.com) writes:

Quote:

Originally Posted by

firstname, lastname1, lastname2, EMAIL

>

Quote:

Originally Posted by

Table has user names and email, I would like to generate a 5th column
called DisplayName.
The email Id is sometimes firstname.lastname1.lastname2@. and others
just firstname.lastname1@.

>

Quote:

Originally Posted by

I would like to generate the display name exactly like the email eg
firstname.lastname1.lastname2@. displayName = firstname lastname1
lastname2.....so for james.smith display name = James Smith and for
james.earl.smith displayName = James Earl Smith etc etc

>

Quote:

Originally Posted by

Is there a way that I can check/compare email Id (before the @. part)
with firstname, lastname1 and lastname2 and generate a display name
based on what was used for the email address?

>

Quote:

Originally Posted by

I hope I've explained this well :-)

>
UPDATE tbl
SET DisplayName = CASE substring(lower(email),
1, charindex('@.', email) - 1)
WHEN lower(firstname) + '.' + lower(lastname)
THEN firstname + ' ' + lastname
WHEN lower(firstname) + '.' + lower(lastname) +
'.' + lower(lastname2)
THEN firstname + ' ' + lastname + ' '
lastname2
END
WHERE DisplayName IS NULL
>
I have here assumed that firstname, lastname and lastname2 are entered
with proper case.
>

Thanks! :-)
Anyone know why I'm getting the following error when I run the above?
"Server: Msg 446, Level 16, State 9, Line 1 Cannot resolve collation
conflict for equal to operation."

Its all from the same Table so strange that there would be a Collation
conflict?

Thanks|||Yas (yasar1@.gmail.com) writes:

Quote:

Originally Posted by

Anyone know why I'm getting the following error when I run the above?
"Server: Msg 446, Level 16, State 9, Line 1 Cannot resolve collation
conflict for equal to operation."
>
Its all from the same Table so strange that there would be a Collation
conflict?

Collation is set by column, so it could happen. Use sp_help to review the
collations.

A possible reason that you created the table, changed the database
collation, and then added more columns to the table.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

MS SQL 2K thinks user is both there and NOT there... what gives??

Hi all,
I've restored a database, and MS SQL is giving me conflicting messages
on whether my main login user is there or not.
My main user - padmin - on the old DB was setup as owner, and padmin
is listed under Logins. But when I select my database > Users then
select padmin and check db_owner and OK, I get this message:
Error 15410: User or roll 'padmin' does not exist in this database.
Uhh, it's there, I'm looking at it. When I click on Permissions
button in the same window, I get this message:
Error 15001: Object '(null)' does not exist or is not a valid object
for this operation.
So... I goto Security > Logins and select padmin (the user SQL says
doesn't exist) and manually permit it to have access and db_owner role
of my database. I get this error:
Error 21002: [SQL-DMO] User 'padmin' already exists.
When I try to delete padmin, I get this error:
Error 15174: Login 'padmin' owns one or more database(s). Change the
owner of the following database(s) before dropping login... and it
lists my database.
So, from within my database, padmin doesn't exist and isn't the owner,
but to MS SQL 2000 it does exist and IS the owner.
What gives? How can I get past this? I have programs and many ODBC
connections that use padmin, so I can't simply create another user and
use this. I'm guessing this is nothing more then a bug in MS SQL, but
I have no idea how to resolve it.
Thanks for any ides, solutions, or suggestions... and take care,
Alex.Hi Alex,
You can fix this with the system stored procedure sp_change_users_login.
Try:
EXEC sp_change_users_login 'AutoFix', 'padmin' from the database.
Jacco Schalkwijk
SQL Server MVP
"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0401290903.34126c7c@.posting.google.com...

quote:

---

> Hi all,
> I've restored a database, and MS SQL is giving me conflicting messages
> on whether my main login user is there or not.
> My main user - padmin - on the old DB was setup as owner, and padmin
> is listed under Logins. But when I select my database > Users then
> select padmin and check db_owner and OK, I get this message:
> Error 15410: User or roll 'padmin' does not exist in this database.
> Uhh, it's there, I'm looking at it. When I click on Permissions
> button in the same window, I get this message:
> Error 15001: Object '(null)' does not exist or is not a valid object
> for this operation.
> So... I goto Security > Logins and select padmin (the user SQL says
> doesn't exist) and manually permit it to have access and db_owner role
> of my database. I get this error:
> Error 21002: [SQL-DMO] User 'padmin' already exists.
> When I try to delete padmin, I get this error:
> Error 15174: Login 'padmin' owns one or more database(s). Change the
> owner of the following database(s) before dropping login... and it
> lists my database.
> So, from within my database, padmin doesn't exist and isn't the owner,
> but to MS SQL 2000 it does exist and IS the owner.
> What gives? How can I get past this? I have programs and many ODBC
> connections that use padmin, so I can't simply create another user and
> use this. I'm guessing this is nothing more then a bug in MS SQL, but
> I have no idea how to resolve it.
> Thanks for any ides, solutions, or suggestions... and take care,
> Alex.

---

|||try sp_change_users_login 'update_one', 'padmin', 'padmin' to fix orphaned
user account after db restore.
richard
"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0401290903.34126c7c@.posting.google.com...

quote:

---

> Hi all,
> I've restored a database, and MS SQL is giving me conflicting messages
> on whether my main login user is there or not.
> My main user - padmin - on the old DB was setup as owner, and padmin
> is listed under Logins. But when I select my database > Users then
> select padmin and check db_owner and OK, I get this message:
> Error 15410: User or roll 'padmin' does not exist in this database.
> Uhh, it's there, I'm looking at it. When I click on Permissions
> button in the same window, I get this message:
> Error 15001: Object '(null)' does not exist or is not a valid object
> for this operation.
> So... I goto Security > Logins and select padmin (the user SQL says
> doesn't exist) and manually permit it to have access and db_owner role
> of my database. I get this error:
> Error 21002: [SQL-DMO] User 'padmin' already exists.
> When I try to delete padmin, I get this error:
> Error 15174: Login 'padmin' owns one or more database(s). Change the
> owner of the following database(s) before dropping login... and it
> lists my database.
> So, from within my database, padmin doesn't exist and isn't the owner,
> but to MS SQL 2000 it does exist and IS the owner.
> What gives? How can I get past this? I have programs and many ODBC
> connections that use padmin, so I can't simply create another user and
> use this. I'm guessing this is nothing more then a bug in MS SQL, but
> I have no idea how to resolve it.
> Thanks for any ides, solutions, or suggestions... and take care,
> Alex.

---

|||If you are still having problem tries this.
1. Common problem when the db is moved to another environment and GUI
is used to recreate the user ID.
2. First check sp_helpuser to see if it is present.
3. sp_dropuser to get clean out the error.
4. sp_adduser to give access/assignment.
When moving database from one relocation to another location
everything including the users should be moved because of the
relations they have as each user id and its environment have unique
keys/id.

MS SQL 2K thinks user is both there and NOT there... what gives??

Hi all,
I've restored a database, and MS SQL is giving me conflicting messages
on whether my main login user is there or not.
My main user - padmin - on the old DB was setup as owner, and padmin
is listed under Logins. But when I select my database > Users then
select padmin and check db_owner and OK, I get this message:
Error 15410: User or roll 'padmin' does not exist in this database.
Uhh, it's there, I'm looking at it. When I click on Permissions
button in the same window, I get this message:
Error 15001: Object '(null)' does not exist or is not a valid object
for this operation.
So... I goto Security > Logins and select padmin (the user SQL says
doesn't exist) and manually permit it to have access and db_owner role
of my database. I get this error:
Error 21002: [SQL-DMO] User 'padmin' already exists.
When I try to delete padmin, I get this error:
Error 15174: Login 'padmin' owns one or more database(s). Change the
owner of the following database(s) before dropping login... and it
lists my database.
So, from within my database, padmin doesn't exist and isn't the owner,
but to MS SQL 2000 it does exist and IS the owner.
What gives? How can I get past this? I have programs and many ODBC
connections that use padmin, so I can't simply create another user and
use this. I'm guessing this is nothing more then a bug in MS SQL, but
I have no idea how to resolve it.
Thanks for any ides, solutions, or suggestions... and take care,
Alex.Hi Alex,
You can fix this with the system stored procedure sp_change_users_login.
Try:
EXEC sp_change_users_login 'AutoFix', 'padmin' from the database.
--
Jacco Schalkwijk
SQL Server MVP
"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0401290903.34126c7c@.posting.google.com...
> Hi all,
> I've restored a database, and MS SQL is giving me conflicting messages
> on whether my main login user is there or not.
> My main user - padmin - on the old DB was setup as owner, and padmin
> is listed under Logins. But when I select my database > Users then
> select padmin and check db_owner and OK, I get this message:
> Error 15410: User or roll 'padmin' does not exist in this database.
> Uhh, it's there, I'm looking at it. When I click on Permissions
> button in the same window, I get this message:
> Error 15001: Object '(null)' does not exist or is not a valid object
> for this operation.
> So... I goto Security > Logins and select padmin (the user SQL says
> doesn't exist) and manually permit it to have access and db_owner role
> of my database. I get this error:
> Error 21002: [SQL-DMO] User 'padmin' already exists.
> When I try to delete padmin, I get this error:
> Error 15174: Login 'padmin' owns one or more database(s). Change the
> owner of the following database(s) before dropping login... and it
> lists my database.
> So, from within my database, padmin doesn't exist and isn't the owner,
> but to MS SQL 2000 it does exist and IS the owner.
> What gives? How can I get past this? I have programs and many ODBC
> connections that use padmin, so I can't simply create another user and
> use this. I'm guessing this is nothing more then a bug in MS SQL, but
> I have no idea how to resolve it.
> Thanks for any ides, solutions, or suggestions... and take care,
> Alex.|||try sp_change_users_login 'update_one', 'padmin', 'padmin' to fix orphaned
user account after db restore.
richard
"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0401290903.34126c7c@.posting.google.com...
> Hi all,
> I've restored a database, and MS SQL is giving me conflicting messages
> on whether my main login user is there or not.
> My main user - padmin - on the old DB was setup as owner, and padmin
> is listed under Logins. But when I select my database > Users then
> select padmin and check db_owner and OK, I get this message:
> Error 15410: User or roll 'padmin' does not exist in this database.
> Uhh, it's there, I'm looking at it. When I click on Permissions
> button in the same window, I get this message:
> Error 15001: Object '(null)' does not exist or is not a valid object
> for this operation.
> So... I goto Security > Logins and select padmin (the user SQL says
> doesn't exist) and manually permit it to have access and db_owner role
> of my database. I get this error:
> Error 21002: [SQL-DMO] User 'padmin' already exists.
> When I try to delete padmin, I get this error:
> Error 15174: Login 'padmin' owns one or more database(s). Change the
> owner of the following database(s) before dropping login... and it
> lists my database.
> So, from within my database, padmin doesn't exist and isn't the owner,
> but to MS SQL 2000 it does exist and IS the owner.
> What gives? How can I get past this? I have programs and many ODBC
> connections that use padmin, so I can't simply create another user and
> use this. I'm guessing this is nothing more then a bug in MS SQL, but
> I have no idea how to resolve it.
> Thanks for any ides, solutions, or suggestions... and take care,
> Alex.|||If you are still having problem tries this.
1. Common problem when the db is moved to another environment and GUI
is used to recreate the user ID.
2. First check sp_helpuser to see if it is present.
3. sp_dropuser to get clean out the error.
4. sp_adduser to give access/assignment.
When moving database from one relocation to another location
everything including the users should be moved because of the
relations they have as each user id and its environment have unique
keys/id.

MS SQL 2005 Workgroup licensing question

Hi,
I am a bit confused about the licensing schemes for MS SQL.
There is a "Processor" licnese (about $4000) and a "Server +
User/Device CAL" for $740 (5 CALs + $150 per additional CAL).
It says:
Processor Licensing Model. Under this model, a license is required for
each physical or virtual processor accessed by an operating system
environment running SQL Server. This license does not require any
device or user client access licenses (CALs).
Server plus Device CALs. Under this model, a server license is required
for each operating system environment running an instance of SQL
Server, as well as a CAL for each client device that accesses a system
running SQL Server.
Server plus User CALs. Under this model, a server license is required
for each operating system environment running an instance of SQL
Server, as well as a CAL for each user that accesses a system running
SQL Server.
If I am installing the MS SQL on one web server running Windows 2003
Server, accessible by corporate users over Internet, which licensing
model is suitable?
TIA.Calculate how many different users access the server. Not at once,
all together over time. Calculate the cost of that many CALs compared
to the per-processor price. You probably will end up with
per-processor pricing.
Roy Harvey
Beacon Falls, CT
On 26 Jul 2006 10:03:32 -0700, ashkaan57@.hotmail.com wrote:

>Hi,
>I am a bit confused about the licensing schemes for MS SQL.
>There is a "Processor" licnese (about $4000) and a "Server +
>User/Device CAL" for $740 (5 CALs + $150 per additional CAL).
>It says:
>Processor Licensing Model. Under this model, a license is required for
>each physical or virtual processor accessed by an operating system
>environment running SQL Server. This license does not require any
>device or user client access licenses (CALs).
>Server plus Device CALs. Under this model, a server license is required
>for each operating system environment running an instance of SQL
>Server, as well as a CAL for each client device that accesses a system
>running SQL Server.
>Server plus User CALs. Under this model, a server license is required
>for each operating system environment running an instance of SQL
>Server, as well as a CAL for each user that accesses a system running
>SQL Server.
>If I am installing the MS SQL on one web server running Windows 2003
>Server, accessible by corporate users over Internet, which licensing
>model is suitable?
>TIA.|||The definitive answers to licensing questions are at:
http://www.microsoft.com/licensing/default.mspx
My take:
You may recall, that the processor license is required for
internet/intranet/extranet usage UNLESS all users will have a proper CAL.
(That even includes a single small query populating a small list box on a
web page.)
If your web site is restricted to company users only, and if all company
users that will be accessing SQL Server have an existing SQL Server CAL,
then I believe that you are covered. (Subject to verification with VL.) If
all company users do not have SQL Server CALs, then you most likely need a
processor license -or additional CALs.
I do not think that any non-company (or extranet) users would be included
without the processor license -unless, upon software audit, you can prove
the existence of CALs.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<ashkaan57@.hotmail.com> wrote in message
news:1153933412.130178.59290@.s13g2000cwa.googlegroups.com...
> Hi,
> I am a bit confused about the licensing schemes for MS SQL.
> There is a "Processor" licnese (about $4000) and a "Server +
> User/Device CAL" for $740 (5 CALs + $150 per additional CAL).
> It says:
> Processor Licensing Model. Under this model, a license is required for
> each physical or virtual processor accessed by an operating system
> environment running SQL Server. This license does not require any
> device or user client access licenses (CALs).
> Server plus Device CALs. Under this model, a server license is required
> for each operating system environment running an instance of SQL
> Server, as well as a CAL for each client device that accesses a system
> running SQL Server.
> Server plus User CALs. Under this model, a server license is required
> for each operating system environment running an instance of SQL
> Server, as well as a CAL for each user that accesses a system running
> SQL Server.
> If I am installing the MS SQL on one web server running Windows 2003
> Server, accessible by corporate users over Internet, which licensing
> model is suitable?
> TIA.
>

MS SQL 2005 Workgroup licensing question

Hi,
I am a bit confused about the licensing schemes for MS SQL.
There is a "Processor" licnese (about $4000) and a "Server +
User/Device CAL" for $740 (5 CALs + $150 per additional CAL).
It says:
Processor Licensing Model. Under this model, a license is required for
each physical or virtual processor accessed by an operating system
environment running SQL Server. This license does not require any
device or user client access licenses (CALs).
Server plus Device CALs. Under this model, a server license is required
for each operating system environment running an instance of SQL
Server, as well as a CAL for each client device that accesses a system
running SQL Server.
Server plus User CALs. Under this model, a server license is required
for each operating system environment running an instance of SQL
Server, as well as a CAL for each user that accesses a system running
SQL Server.
If I am installing the MS SQL on one web server running Windows 2003
Server, accessible by corporate users over Internet, which licensing
model is suitable?
TIA.Calculate how many different users access the server. Not at once,
all together over time. Calculate the cost of that many CALs compared
to the per-processor price. You probably will end up with
per-processor pricing.
Roy Harvey
Beacon Falls, CT
On 26 Jul 2006 10:03:32 -0700, ashkaan57@.hotmail.com wrote:
>Hi,
>I am a bit confused about the licensing schemes for MS SQL.
>There is a "Processor" licnese (about $4000) and a "Server +
>User/Device CAL" for $740 (5 CALs + $150 per additional CAL).
>It says:
>Processor Licensing Model. Under this model, a license is required for
>each physical or virtual processor accessed by an operating system
>environment running SQL Server. This license does not require any
>device or user client access licenses (CALs).
>Server plus Device CALs. Under this model, a server license is required
>for each operating system environment running an instance of SQL
>Server, as well as a CAL for each client device that accesses a system
>running SQL Server.
>Server plus User CALs. Under this model, a server license is required
>for each operating system environment running an instance of SQL
>Server, as well as a CAL for each user that accesses a system running
>SQL Server.
>If I am installing the MS SQL on one web server running Windows 2003
>Server, accessible by corporate users over Internet, which licensing
>model is suitable?
>TIA.|||The definitive answers to licensing questions are at:
http://www.microsoft.com/licensing/default.mspx
My take:
You may recall, that the processor license is required for
internet/intranet/extranet usage UNLESS all users will have a proper CAL.
(That even includes a single small query populating a small list box on a
web page.)
If your web site is restricted to company users only, and if all company
users that will be accessing SQL Server have an existing SQL Server CAL,
then I believe that you are covered. (Subject to verification with VL.) If
all company users do not have SQL Server CALs, then you most likely need a
processor license -or additional CALs.
I do not think that any non-company (or extranet) users would be included
without the processor license -unless, upon software audit, you can prove
the existence of CALs.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<ashkaan57@.hotmail.com> wrote in message
news:1153933412.130178.59290@.s13g2000cwa.googlegroups.com...
> Hi,
> I am a bit confused about the licensing schemes for MS SQL.
> There is a "Processor" licnese (about $4000) and a "Server +
> User/Device CAL" for $740 (5 CALs + $150 per additional CAL).
> It says:
> Processor Licensing Model. Under this model, a license is required for
> each physical or virtual processor accessed by an operating system
> environment running SQL Server. This license does not require any
> device or user client access licenses (CALs).
> Server plus Device CALs. Under this model, a server license is required
> for each operating system environment running an instance of SQL
> Server, as well as a CAL for each client device that accesses a system
> running SQL Server.
> Server plus User CALs. Under this model, a server license is required
> for each operating system environment running an instance of SQL
> Server, as well as a CAL for each user that accesses a system running
> SQL Server.
> If I am installing the MS SQL on one web server running Windows 2003
> Server, accessible by corporate users over Internet, which licensing
> model is suitable?
> TIA.
>

MS SQL 2005 Express

Hi,

I have just installed MS SQL 2005 Express for testing purpose but a
unabe t gn.. what user id and passwrd should use?

Many Thanks,
Jassim Rahma

*** Sent via Developersdex http://www.developersdex.com ***Jassim Rahma (jrahma@.hotmail.com) writes:
> I have just installed MS SQL 2005 Express for testing purpose but a
> unabe t gn.. what user id and passwrd should use?

You can always connect with Windows Authentication.

Note that questions about SQL 2005 are best asked in the SQL 2005
newsgoups, see http://go.microsoft.com/fwlink/?linkid=31765 for
access information.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I tried that but didn't work..

Many Thanks,
Jassim Rahma

*** Sent via Developersdex http://www.developersdex.com ***|||Jassim Rahma (jrahma@.hotmail.com) writes:
> I tried that but didn't work..

What didn't work? And what exactly does "did not work mean"? Error message?
Unexpected result? Other?
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp