I can't create a table in TEMPDB

I have a USER wich can Create tables in the production DB, but this USER
can't create tables in TEMPDB.
? What's grong ?Does the user have access to TEMPDB database?
"Eduardo6973" <Eduardo6973@.discussions.microsoft.com> wrote in message
news:DC6F4810-17F5-4E3E-A59B-EAE30255E02F@.microsoft.com...
>I have a USER wich can Create tables in the production DB, but this USER
> can't create tables in TEMPDB.
> What's grong ?|||It's unusual to create non-temporary tables in tempdb. Can you elaborate on
why you need to do this? Perhaps there is an alternate approach.
All users have permissions to create local or global temp tables in tempdb
but CREATE TABLE permission is needed to create 'permanent' tables.
Non-sysadmin role members access tempdb under the guest user security
context so you could grant CREATE TABLE to guest so that non-sysadmin users
can create permanent tables owned by guest in tempdb. Alternatively, you
could add users to tempdb and then grant CREATE TABLE permissions to those
users. However, note that tempdb is recreated at instance startup so all
users, permissions and objects created in tempdb will lost. You'll need to
either reapply those permissions at startup or add the permissions to the
model database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Eduardo6973" <Eduardo6973@.discussions.microsoft.com> wrote in message
news:DC6F4810-17F5-4E3E-A59B-EAE30255E02F@.microsoft.com...
>I have a USER wich can Create tables in the production DB, but this USER
> can't create tables in TEMPDB.
> What's grong ?

I cant connect to my local sql server express db. Please help

Hello,

I need help to connect to my local sql express db in visual studio 2003 in vb.
It currently works with the production db information and I need to test a few things, So i'd like to point it to the local db.

It works this way:
Const CONN_STRING = "server=johndoe;user id=john;password=doe;database=johnd"
Dim conn As SqlConnection = New SqlConnection(Me.CONN_STRING)
conn.Open()

I want to point it to my local db and it doesn't connect.

Dim connectionString As String = "Data Source={myusername\SQLEXPRESS};Initial Catalog=johnd;Trusted_Connection=yes"
Dim conn As SqlConnection = New SqlConnection(connectionString)

Try
conn.Open()
Catch ex As Exception
Response.Write(ex.ToString())
End Try

and even that doesn't work.

When i go to my sql server 2005, it says
MYUSERNAME\SQLEXPRESS (SQL SERVER 9.0.3042 - theworknetwork\myusername

what am i doing wrong ?

Thanks.

You can try two things:

1) If you are an administrator on your local computer, then make sure that your user ID is in the Administrators group and then make that the Administrators group has access to the SQLEXPRESS instance. Change the user ID used by the SQL Server Management Tool with your local machine login, not your network login. If this doesn't work, replace it with the local machine Administrator account.

2) Instead of using Windows authorizations, use SQL Server authorizations. Create a new user in SQL Server specifically for your database. Make this user the dbo. Then use this user name with password in your ConnectionString.

At times, I have issues with Windows users because the passwords are different across the various computers. This has not been the case with SQL Server credentials, which I usually prefer.

Also, try using Integrated_Security in place of Trusted_Connection in the ConnectionString.

|||

Heres what I've tried. I went to that db (johnd), went to the security>users> and there is already a user called dbo

I tried doing Integrated_Security like you said and i got an error saying that is an invalid key. So here is what I have and it still doesn't work.

"Data Source={myusername\SQLEXPRESS};Initial Catalog=intranet;Trusted_Connection=yes;user id=dbo; password=dbo"

Any ideas?

|||

Can you please try with the following connection string if you are using NT Authentication:

Data Source={localmachine\SQLEXPRESS};Initial Catalog=intranet;Trusted_Connection=yes;

If you are using SQL Server User please try with the following connection string:

Data Source={localmachine\SQLEXPRESS};Initial Catalog=intranet;user id=<local sql server user>; password=<password>

Please make sure that you are changing the bold string with appropriate values.

Following URL provides you the steps to create the user:

http://www.microsoft.com/technet/prodtechnol/sql/2005/mgsqlexpwssmse.mspx

|||

I am in microsoft sql server managemen studio Object explorer (on left)
The very first item shows SDAVID\SQLEXPRESS

underneath that i have my database intranet

I then went to security > users [right click] > New User
Under Database User - New,
User Name: SDAVID
Login name
a new window came for Select Login and i found SDAVID [hit okay.]
* so now it shows User name: SDAVID
and login name shows SDAVID

under schemas owned by this user, I choose db_owner and db_securityadmin
under database membership i choose db_owner and db_securityadmin

Now under the code, here is what i have...

Const dbstring = "Data Source={SDAVID\SQLEXPRESS};Initial Catalog=intranet;user id=<sdavid>; password=<sdavid>"

Public Function testConnection()
Dim connectionString As String = "Data Source={SDAVID\SQLEXPRESS};Initial Catalog=intranet;user id=<sdavid>; password=<sdavid>"
Dim conn As SqlConnection = New SqlConnection(ConnectionString)
Dim cmd As SqlCommand = New SqlCommand("selec * from tblUsers", conn)
cmd.CommandType = CommandType.Text
Try
conn.Open()
Catch ex As Exception
Response.Write(ex.ToString())
Finally
conn.Close()
End Try

this generates the following error:
sqlException: Sql server does not exists or access denied.

thanks.

|||

Can you please use the following modified connection string:

Const dbstring = "Data Source=SDAVID\SQLEXPRESS;Initial Catalog=intranet;user id=sdavid; password=sdavid"

|||

Thank you. that did it! ..
Data Source=SDAVID\SQLEXPRESS;Initial Catalog=intranet;Trusted_Connection=yes;

|||

Hey Sri,

I tried it your way with specifying username and password and that did not work. Do you know why this could be ?

in Micrososft Sql Server Mangement Studio, i went to the db, Security > USers and created a user called sdavid with sdavid. I gave the user db_datareader and db_owner an under database roles membership gave it db_owner... i'd like to get the app working sql sever authhentication.

thanks.

I am looking for some technical support/tutor help in KC, Kansas

I am looking for someone to help me with SQL server 2000 (enterprise &
standard editions) production DBA, all the environments are pretty simple,
windows NT & windows 2003. (if you know SQL server 2005 will be a plus). I
would prefer someone live in KC area also.
My situation is I just got a new contract job this week, it seems like no on
e
can help me to get started over there,
I am pretty much all on my own, so far I know I am only involve with Erwin &
Tivoli software,
My daily responsibilities are maintaining of the databases, backup and
restore procedures, DTS packages, schedule jobs, and some T-SQL; such as
store procedures and triggers.
I am in charge of 4 servers, about 200 databases, this company never had a
professional SQL DBA so everything is everywhere. The company resources use
95% on Oracle server so they didn't spend much effort on SQL Server.
Now, in addition, I am doing migration from SQL server 2000 to 2005. I would
need someone that have hands on experience and able to show me step to step
procedures.
I am not sure if this will help you to understand what I need help on,
but if you think you can help me or you know someone that can help me please
reply. Thanks
P/S: I will pay accordingly.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200707/1Hi,
I am not actually in Kansas. Actually I'm quite a few miles away. But
if you don't mind getting help from Dublin (Ireland) I can support you
on both SQL Server 2000 and 2005! If you're interested let me know how
I can get in touch with you.
Jonathan
ajsql via droptable.com wrote:
> I am looking for someone to help me with SQL server 2000 (enterprise &
> standard editions) production DBA, all the environments are pretty simple,
> windows NT & windows 2003. (if you know SQL server 2005 will be a plus). I
> would prefer someone live in KC area also.
> My situation is I just got a new contract job this week, it seems like no
one
> can help me to get started over there,
> I am pretty much all on my own, so far I know I am only involve with Erwin
&
> Tivoli software,
> My daily responsibilities are maintaining of the databases, backup and
> restore procedures, DTS packages, schedule jobs, and some T-SQL; such as
> store procedures and triggers.
> I am in charge of 4 servers, about 200 databases, this company never had a
> professional SQL DBA so everything is everywhere. The company resources us
e
> 95% on Oracle server so they didn't spend much effort on SQL Server.
> Now, in addition, I am doing migration from SQL server 2000 to 2005. I wou
ld
> need someone that have hands on experience and able to show me step to ste
p
> procedures.
> I am not sure if this will help you to understand what I need help on,
> but if you think you can help me or you know someone that can help me plea
se
> reply. Thanks
> P/S: I will pay accordingly.
>

I am looking for some technical support/tutor help in KC, Kansas

I am looking for someone to help me with SQL server 2000 (enterprise &
standard editions) production DBA, all the environments are pretty simple,
windows NT & windows 2003. (if you know SQL server 2005 will be a plus). I
would prefer someone live in KC area also.
My situation is I just got a new contract job this week, it seems like no one
can help me to get started over there,
I am pretty much all on my own, so far I know I am only involve with Erwin &
Tivoli software,
My daily responsibilities are maintaining of the databases, backup and
restore procedures, DTS packages, schedule jobs, and some T-SQL; such as
store procedures and triggers.
I am in charge of 4 servers, about 200 databases, this company never had a
professional SQL DBA so everything is everywhere. The company resources use
95% on Oracle server so they didn't spend much effort on SQL Server.
Now, in addition, I am doing migration from SQL server 2000 to 2005. I would
need someone that have hands on experience and able to show me step to step
procedures.
I am not sure if this will help you to understand what I need help on,
but if you think you can help me or you know someone that can help me please
reply. Thanks
P/S: I will pay accordingly.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200707/1Hi,
I am not actually in Kansas. Actually I'm quite a few miles away. But
if you don't mind getting help from Dublin (Ireland) I can support you
on both SQL Server 2000 and 2005! If you're interested let me know how
I can get in touch with you.
Jonathan
ajsql via SQLMonster.com wrote:
> I am looking for someone to help me with SQL server 2000 (enterprise &
> standard editions) production DBA, all the environments are pretty simple,
> windows NT & windows 2003. (if you know SQL server 2005 will be a plus). I
> would prefer someone live in KC area also.
> My situation is I just got a new contract job this week, it seems like no one
> can help me to get started over there,
> I am pretty much all on my own, so far I know I am only involve with Erwin &
> Tivoli software,
> My daily responsibilities are maintaining of the databases, backup and
> restore procedures, DTS packages, schedule jobs, and some T-SQL; such as
> store procedures and triggers.
> I am in charge of 4 servers, about 200 databases, this company never had a
> professional SQL DBA so everything is everywhere. The company resources use
> 95% on Oracle server so they didn't spend much effort on SQL Server.
> Now, in addition, I am doing migration from SQL server 2000 to 2005. I would
> need someone that have hands on experience and able to show me step to step
> procedures.
> I am not sure if this will help you to understand what I need help on,
> but if you think you can help me or you know someone that can help me please
> reply. Thanks
> P/S: I will pay accordingly.
>

Hw can the cube be modified after deployment?

Hi,

We used cube in our project.

And the project is released to production environment.

Now we need to modify the cube.

Can anyone have any idea what are the ways we can handle this?

Appreciate any suggestion.

Sachin!

If this is an SSAS2005 cube you will have a project in BI-Developer Studio? Open the project and make the changes and redeploy the script to the SSAS2005 server.

The other way is to reingeneer a deployed cube. BI-Dev Studio have a project for this as well: "Import Analysis Services 9 database". Once you have a new project you can start making changes.

HTH

Thomas Ivarsson

|||The third alternative is to connect online to the cube. In Visual Studio go to File -> Open -> Analysis Services Database, and you will end up making changes directly to the cube on the server without having to deploy the changes - just hitting Save will make the changes immediatelly.|||

But without a blueprint/copy of what you have done. You should always work with a project?

/Thomas Ivarsson

|||In online mode you still have a project - it's just online project - everything is on the server. It is ultimately up to the developer in which mode he wants to work. (BTW, in AS2000 the only available mode was online mode).|||

We have deployed product at many client locations.

Now we need to add few things to the cube

But it is not feasible to go and change manually at all locations and same time client may not want that.

We are looking after creating an update for the product.

Now the question is how to update cube? One option is delete existing cube and create again with new xmla script and process cube.

Can you please suggest any other way to do so?