Metadata Services: setup

Showing posts with label setup. Show all posts

Friday, March 30, 2012

No Mail for Me!

Hey all,

I've got a Enterprise SQL 2000 server setup for my websites. I wanted to use the operators and sqlmail SP's for some things. So i setup everything but i'm not able to actually send any email.

I have outlook 2002 installed on the server and the server account is set to the mail profile 'SQLMail' and this account is set to run both MSSQLServer and SQL Agent.

Here's the catch. We run exchange here on a domain XYZ. my server is a standalone and does not actully connect to the XYZ domain. Does this mean that i can't use the mail capabilities in SQL?

When setting things up i'm able to test connections to my profile and i get the A-OK messages i should expect BUT when i try to test an email or email pager account for an operator it fails. My SQL Agent log shows:

[260] Unable to start mail session (reason: Unable to logon (reason: Unable to get the default MAPI Message Store due to MAPI error 273:
The information store could not be opened); check the mail profile and/or the SQLSERVERAGENT service startup account)

Any ideas?Couple things you should test:

1. Can you send mail successfully when logged into the machine with Sql run account? This should answer your questions about the domain.

2. Is Outlook your default mail client when logged in with run account? Check Internet Options, Programs tab, Under Email.

3. Under Mail in the Control Panel make sure the mail profile you select in Sql Agent is used when starting Outlook and setup correctly.

Hope this helps.

No login name for database user.

I am using SQL2000. I took a backup of the database on the live server to setup the database on my new development computer. In the tables, there are 2 owners’ dbo and indiankarma. The tables that are owned by indiankarma are the tables that the site runs from.

The problem: The database user was created by the .bak file and does not have a login name. I created a security login named indiankarma and set the password, default database, server roles, BUT when I set the database access and click OK, it says User 'Indiankarma' already exists. I tried to delete the database user and start from scratch but it tells me the selected user cannot be dropped because the user owns objects.

Now I have tried sp_changedbowner 'indiankarma' which does give the security login name indiankarma database access but it makes the user dbo not indiankarma. I need the web application to read indiankarma.[tablename] not dbo.[tablename]

Can anyone help me with this problem?? Confused

This is a common issue after restoring a database. Check the following blog

http://weblogs.asp.net/steveschofield/archive/2005/12/31/434280.aspx

Regards

|||

I don't think I explained the problem correctly. When I restored the data base it created 2 sets of tables for each table. One set owned by dbo and the other set by indiankarma. So I have a table that is indiankarma.ikuserinfo and a table right below it that is dbo.ikuserinfo. All the site data is in the indiankarma owned tables. (see below 1.1)

1.1

The problem is that the 'indiankarma' database user has no login name. (See below 1.2).

1.2 1.2

Also, the security login 'indiankarma' does not have access to the database (see below 1.3) and when I try to give it access, I get this error 'User 'Indiankarma' already exists.' (see below 1.4)

1.3 1.3

1.4

I need to know what I can do to get database user 'indiankara' a login name and how to permit security login 'indiankarma' database access with the user 'indiankarma'. So it looks like the figure below (see below 1.5) but when I click ok, it does not give me the error. Please help!!! Sorry for all the images, I am bad at explaining problems thought they might help!

1.5

|||

1.1

The problem is that the 'indiankarma' database user has no login name. (See below 1.2).

1.2 1.2

Also, the security login 'indiankarma' does not have access to the database (see below 1.3) and when I try to give it access, I get this error 'User 'Indiankarma' already exists.' (see below 1.4)

1.3 1.3

1.4

1.5

|||

1.1

The problem is that the 'indiankarma' database user has no login name. (See below 1.2).

1.2 1.2

Also, the security login 'indiankarma' does not have access to the database (see below 1.3) and when I try to give it access, I get this error 'User 'Indiankarma' already exists.' (see below 1.4)

1.3 1.3

1.4

1.5

|||

Also, the security login 'indiankarma' does not have access to the database (see below 1.3) and when I try to give it access, I get this error 'User 'Indiankarma' already exists.' (see below 1.4)1.3
1.3

1.4
I need to know what I can do to get database user 'indiankara' a login name and how to permit security login 'indiankarma' database access with the user 'indiankarma'. So it looks like the figure below (see below 1.5) but when I click ok, it does not give me the error. Please help!!! Sorry for all the images, I am bad at explaining problems thought they might help!1.5

Monday, March 26, 2012

No Data returned from OPENQUERY to Active Directory

Alan, not sure if it matters, but I usually do the
ADIS/LDAP calls more like this format... Check the
Linked Server also, for correct setup and security. Bruce
SELECT * FROM OPENQUERY( ADSI,'<LDAP://mydomain>;
((objectClass=User));distinguishedname,h
omePhone')
where distinguishedname like '%a%'

>--Original Message--
>I am trying to query our active directory for user
information, but even
>though I get the query to work I am getting no data
back. I have a linked
>server to the active directory from SQL Server 2000 and
I am running the
>query in the Query Analyzer.
>My query is as follows:
>select * from openquery(adsi, 'select name, homephone
from
>''ldap://DC=mydomain,DC=com'' where objectclass
= ''User'' ')
>This query will complete without error, but no data is
returned. I have
>seen one other question of this nature here, but I saw
no final resolution.
>What is wrong?
>Alan
>--
>Message posted via http://www.droptable.com
>.
>Bruce,
thanks for the response, but I tried what you suggested and still the query
returned no data. It completed without error just no data.
Thanks,
Alan
Message posted via http://www.droptable.com|||Alan, not sure why youre getting no data back then.
You're sure of the domain name? there's no special
security on your AD to prevent you from accessing? The
linked sever is setup correctly? like so..'
sp_addlinkedserver 'ADSI', 'Active Directory Service
Interfaces', 'ADSDSOObject', 'adsdatasource'
go
Are you sure the data sits in the User ObjectClass?
Might be somewhere else, check it.
There was a max 1000 row limit by default and we had to
have that kicked up to get more then 1000 rows returned.
These links talk about that...
http://support.novell.com/cgi-
bin/search/searchtid.cgi?/10081596.htm
http://www.ldapadministrator.com/fo...wtopic.php?t=14

>--Original Message--
>Bruce,
>thanks for the response, but I tried what you suggested
and still the query
>returned no data. It completed without error just no
data.
>Thanks,
>Alan
>--
>Message posted via http://www.droptable.com
>.
>|||Bruce,
I ran an export of the data in the user objects using ldifde and got back
exactly what I expected, but the same query in SQL Server Query Analyzer
comes back empty.
I guess it could be something with the link, but it was set up according to
the instructions I found on the web. The link was created in Enterprise
manager, but using the same settings that you specified in the
sp_addlinkedserver statement. It could also be a user security issue, but
I have tried logining in as the admin, SQL Sever admin and myself with no
data back.
Still playing around with it.
Alan
Message posted via http://www.droptable.com|||Finally, thanks Bruce. I was reading your posting and I was finally able to
pull data.
I'm trying to pull just users that are a member of a certain group, how can
I do that?
This is what I have but not working; however, I was able to used your query
just to get a start and that was a big help.
SELECT *
FROM OPENQUERY( ADSI,
'SELECT cn
FROM ''LDAP://internal/OU=Account
Executives,DC=internal,DC=homequest,DC=c
om''
WHERE objectClass = ''users''')
GO
"Bruce de Freitas" wrote:

> Alan, not sure if it matters, but I usually do the
> ADIS/LDAP calls more like this format... Check the
> Linked Server also, for correct setup and security. Bruce
>
> SELECT * FROM OPENQUERY( ADSI,'<LDAP://mydomain>;
> ((objectClass=User));distinguishedname,h
omePhone')
> where distinguishedname like '%a%'
>
>
> information, but even
> back. I have a linked
> I am running the
> from
> = ''User'' ')
> returned. I have
> no final resolution.
>|||Sonya, this query would list all the GROUPs.
SELECT * FROM OPENQUERY( adsi,'<ldap://mydomain>;
(&(objectCategory=GROUP)); distinguishedname,CN')
You'd then have to join all the Users to what groups they are in, if
that is what youre trying to do... Bruce
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Thank you, after playing with it for awhile I was able to get it to work.
Do you know if there is a way to extract users' contact folder from the
server-level?
"Bruce de Freitas" wrote:

> Sonya, this query would list all the GROUPs.
> SELECT * FROM OPENQUERY( adsi,'<ldap://mydomain>;
> (&(objectCategory=GROUP)); distinguishedname,CN')
>
> You'd then have to join all the Users to what groups they are in, if
> that is what youre trying to do... Bruce
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>

Wednesday, March 21, 2012

No Access to the PropertiesTab

Hello Community
I've setup a Reporting Server with different reports and users, most of
the features work fine. I'm now tring to add a user which is able to
modifiy the security roles assignment for his reports. I granted him
Content Manager, but I couldn't even access the PropertiesTab from
Reports or Folders.
Is it possible to grant a user the right to modifiy the security
settings from his reports?
Thanks for any helpFound the Solution: The user need access (at least Browser) to the Root
Folder of Reporting Service..
ulrich@.webrevolution.ch schrieb:
> Hello Community
> I've setup a Reporting Server with different reports and users, most of
> the features work fine. I'm now tring to add a user which is able to
> modifiy the security roles assignment for his reports. I granted him
> Content Manager, but I couldn't even access the PropertiesTab from
> Reports or Folders.
> Is it possible to grant a user the right to modifiy the security
> settings from his reports?
> Thanks for any help

No access to database

I have a Windows Group setup to access a SQL server, say (SQLSUPPORT as windows group) and it's a login account to a SQL server... I have a Windows user, DOMAIN\memberA (as member of the group SQLSUPPORT), and it also has a specific login access account to a SQL server but no database user access...

SQLSUPPORT has db_datareader and db_datawriter permissions to DATABASEa but not DOMAIN\memberA... DOMAIN\memberA does not have specific access to DATABASEa...

I get the error message that DOMAIN\memberA does not have permissions to the database.

How can this be? Why can't the user account that's a member of a group have access to the database when the group has been granted db_datareader and db_datawriter permissions?

BUT, does domain\SQLSupport have permission to access the database?

|||

Yes, SQLSUPPORT has db_datareader and db_datawriter permissions to DATABASEa but not DOMAIN\memberA... DOMAIN\memberA does not have specific access to DATABASEa...

|||

Permissions are cummulative with deny taking precedence. So my first guess it that memberA is impacted by a deny somewhere. Don't just look at the one group - make sure to look at all groups and roles as well as individual permissions and denies for that user account.

-Sue

sql

Monday, March 12, 2012

NIC Teaming

I have a Dell 2850 that is being setup for a SQL database. In the past (for
example my Exchange 2003 server) I have had problems when teaming the NIC
cards on the server in a load balancing mode.
My question is, for SQL server (this server will also run IIS) where clients
will connect via a browser to view documents, what is the best method for
teaming the NIC's? Is there any benefit in using load balancing? When
dealing with my back-up server I have been told that teaming NIC cards for
load balancing does not improve bandwidth, if so what is the benefit for
teaming two NIC's for load balancing.
Thank You.A lot of the earlier teaming software had serious issues, and I got burned
resulting in me not using it for a long time.

The newer generations are
pretty solid. I don't have any issues using it now. Just make sure you
have the lates BIOS and load balancing software.
There are several benefits of using load balancing of course. One, you have
more paths to push the data over. Two, you have more redundancy.
Typically, you never approach the maximum capacity of your NICs anyway if
you are using 1GB. The bottlenecks usually occur in other areas of the
system.
"mcwe_admin" <mcweadmin@.discussions.microsoft.com> wrote in message
news:90F8DA61-CB2B-4E7A-BEA9-3716F403EF8A@.microsoft.com...
> I have a Dell 2850 that is being setup for a SQL database. In the past
(for
> example my Exchange 2003 server) I have had problems when teaming the NIC
> cards on the server in a load balancing mode.
> My question is, for SQL server (this server will also run IIS) where
clients
> will connect via a browser to view documents, what is the best method for
> teaming the NIC's? Is there any benefit in using load balancing? When
> dealing with my back-up server I have been told that teaming NIC cards for
> load balancing does not improve bandwidth, if so what is the benefit for
> teaming two NIC's for load balancing.
> Thank You.|||Would load-balancing be preferred over fault tolerance mode for a sql
database server running iis?
Thanks.
"Derrick Leggett" wrote:

> A lot of the earlier teaming software had serious issues, and I got burned
> resulting in me not using it for a long time.

The newer generations a
re
> pretty solid. I don't have any issues using it now. Just make sure you
> have the lates BIOS and load balancing software.
> There are several benefits of using load balancing of course. One, you ha
ve
> more paths to push the data over. Two, you have more redundancy.
> Typically, you never approach the maximum capacity of your NICs anyway if
> you are using 1GB. The bottlenecks usually occur in other areas of the
> system.
>
> "mcwe_admin" <mcweadmin@.discussions.microsoft.com> wrote in message
> news:90F8DA61-CB2B-4E7A-BEA9-3716F403EF8A@.microsoft.com...
> (for
> clients
>
>|||Not if you don't need it. If you're not getting and network latency or wait
times, then just stick with fault tolerance. There's no reason to introduce
more variables into the equation if you don't need them.
The bigger issue is running IIS on the database server.

I wouldn't mind
this for a reporting database server, but would try my hardest to avoid it
on the main, critical production database servers of a corporation if I
could avoid it.
"mcwe_admin" <mcweadmin@.discussions.microsoft.com> wrote in message
news:4332A3FA-489E-4FE6-B439-8DC77DBD47BF@.microsoft.com...[vbcol=seagreen]
> Would load-balancing be preferred over fault tolerance mode for a sql
> database server running iis?
> Thanks.
> "Derrick Leggett" wrote:
>
burned[vbcol=seagreen]
are[vbcol=seagreen]
have[vbcol=seagreen]
if[vbcol=seagreen]
past[vbcol=seagreen]
NIC[vbcol=seagreen]
for[vbcol=seagreen]
When[vbcol=seagreen]
for[vbcol=seagreen]
for[vbcol=seagreen]|||Note that there is only about 100 users that will be accessing this server,
IIS will be needed as the front end for the database. With this amount of
users do you think that I would need a seperate server for IIS?
The server is a Dell 2850, dual processor with 2 Gig of Ram.
What types of problems do you think could occur?
Thanks.
"Derrick Leggett" wrote:

> Not if you don't need it. If you're not getting and network latency or wa
it
> times, then just stick with fault tolerance. There's no reason to introdu
ce
> more variables into the equation if you don't need them.
> The bigger issue is running IIS on the database server.

I wouldn't mi
nd
> this for a reporting database server, but would try my hardest to avoid it
> on the main, critical production database servers of a corporation if I
> could avoid it.
>
> "mcwe_admin" <mcweadmin@.discussions.microsoft.com> wrote in message
> news:4332A3FA-489E-4FE6-B439-8DC77DBD47BF@.microsoft.com...
> burned
> are
> have
> if
> past
> NIC
> for
> When
> for
> for
>
>

NIC Teaming

I have a Dell 2850 that is being setup for a SQL database. In the past (for
example my Exchange 2003 server) I have had problems when teaming the NIC
cards on the server in a load balancing mode.
My question is, for SQL server (this server will also run IIS) where clients
will connect via a browser to view documents, what is the best method for
teaming the NIC's? Is there any benefit in using load balancing? When
dealing with my back-up server I have been told that teaming NIC cards for
load balancing does not improve bandwidth, if so what is the benefit for
teaming two NIC's for load balancing.
Thank You.
A lot of the earlier teaming software had serious issues, and I got burned
resulting in me not using it for a long time.

The newer generations are
pretty solid. I don't have any issues using it now. Just make sure you
have the lates BIOS and load balancing software.
There are several benefits of using load balancing of course. One, you have
more paths to push the data over. Two, you have more redundancy.
Typically, you never approach the maximum capacity of your NICs anyway if
you are using 1GB. The bottlenecks usually occur in other areas of the
system.
"mcwe_admin" <mcweadmin@.discussions.microsoft.com> wrote in message
news:90F8DA61-CB2B-4E7A-BEA9-3716F403EF8A@.microsoft.com...
> I have a Dell 2850 that is being setup for a SQL database. In the past
(for
> example my Exchange 2003 server) I have had problems when teaming the NIC
> cards on the server in a load balancing mode.
> My question is, for SQL server (this server will also run IIS) where
clients
> will connect via a browser to view documents, what is the best method for
> teaming the NIC's? Is there any benefit in using load balancing? When
> dealing with my back-up server I have been told that teaming NIC cards for
> load balancing does not improve bandwidth, if so what is the benefit for
> teaming two NIC's for load balancing.
> Thank You.
|||Would load-balancing be preferred over fault tolerance mode for a sql
database server running iis?
Thanks.
"Derrick Leggett" wrote:

> A lot of the earlier teaming software had serious issues, and I got burned
> resulting in me not using it for a long time.

The newer generations are
> pretty solid. I don't have any issues using it now. Just make sure you
> have the lates BIOS and load balancing software.
> There are several benefits of using load balancing of course. One, you have
> more paths to push the data over. Two, you have more redundancy.
> Typically, you never approach the maximum capacity of your NICs anyway if
> you are using 1GB. The bottlenecks usually occur in other areas of the
> system.
>
> "mcwe_admin" <mcweadmin@.discussions.microsoft.com> wrote in message
> news:90F8DA61-CB2B-4E7A-BEA9-3716F403EF8A@.microsoft.com...
> (for
> clients
>
>
|||Not if you don't need it. If you're not getting and network latency or wait
times, then just stick with fault tolerance. There's no reason to introduce
more variables into the equation if you don't need them.
The bigger issue is running IIS on the database server.

I wouldn't mind
this for a reporting database server, but would try my hardest to avoid it
on the main, critical production database servers of a corporation if I
could avoid it.
"mcwe_admin" <mcweadmin@.discussions.microsoft.com> wrote in message
news:4332A3FA-489E-4FE6-B439-8DC77DBD47BF@.microsoft.com...[vbcol=seagreen]
> Would load-balancing be preferred over fault tolerance mode for a sql
> database server running iis?
> Thanks.
> "Derrick Leggett" wrote:
burned[vbcol=seagreen]
are[vbcol=seagreen]
have[vbcol=seagreen]
if[vbcol=seagreen]
past[vbcol=seagreen]
NIC[vbcol=seagreen]
for[vbcol=seagreen]
When[vbcol=seagreen]
for[vbcol=seagreen]
for[vbcol=seagreen]
|||Note that there is only about 100 users that will be accessing this server,
IIS will be needed as the front end for the database. With this amount of
users do you think that I would need a seperate server for IIS?
The server is a Dell 2850, dual processor with 2 Gig of Ram.
What types of problems do you think could occur?
Thanks.
"Derrick Leggett" wrote:

> Not if you don't need it. If you're not getting and network latency or wait
> times, then just stick with fault tolerance. There's no reason to introduce
> more variables into the equation if you don't need them.
> The bigger issue is running IIS on the database server.

I wouldn't mind
> this for a reporting database server, but would try my hardest to avoid it
> on the main, critical production database servers of a corporation if I
> could avoid it.
>
> "mcwe_admin" <mcweadmin@.discussions.microsoft.com> wrote in message
> news:4332A3FA-489E-4FE6-B439-8DC77DBD47BF@.microsoft.com...
> burned
> are
> have
> if
> past
> NIC
> for
> When
> for
> for
>
>

Friday, March 9, 2012

news server for comp.databases.ms-sqlserver

I know the news server i used to setup for the newsgroup im posting is
news.microsoft.com
Whats the news server to post to comp.databases.ms-sqlserver ?
ThanksYou can use any newsserver which let you post messages through and
lists the above mentioned one. For a list of available newsserver just
search in google.
e.g. here: http://www.cab.u-szeged.hu/linux/mi...ws-servers.html
HTH, Jens Suessmeyer.

news server for comp.databases.ms-sqlserver

Monday, February 20, 2012

Newbie: Merge Replication

I have setup merge replication and it appears to be working fine
multiple publishers to a single subscriber. with continuous push
subscription
If the subscribing SQL Server is unavailable for a period of time the
replication monitor shows an error
"could not connect to SERVERNAME"
Ok so fairly easy to understand.
Now when the subscribing server is available again it does not seem to
connect again. I can click the "start synchronizing" option from the
replication monitor, however I would have thought continuous updating would
reconnect when available.
If this is the case,
1. How can I make it connect/start sycnronising again sooner automatically,
without user invervention?
2. Am I able to call the start synchronising feature through commands so
that I can have a force update type feature through code.
Thanks in advance.
Cheers,
Tim
Timmeah,
you could schedule the merge agent to run once a minute rather than
continuously. Alternatively you could force the job steps to run in a loop.
To start the merge agent in TSQL you can use sp_start_job.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Friday, March 30, 2012

No Mail for Me!

No login name for database user.

Monday, March 26, 2012

No Data returned from OPENQUERY to Active Directory

Wednesday, March 21, 2012

No Access to the PropertiesTab

No access to database

Monday, March 12, 2012

NIC Teaming

NIC Teaming

Friday, March 9, 2012

news server for comp.databases.ms-sqlserver

news server for comp.databases.ms-sqlserver

Monday, February 20, 2012

Newbie: Merge Replication

Metadata Services

Blog Archive

About Me