.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Cannot determine how to set owner to install database design

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server
 
My compatibility settings are fine. Anyone know how to to this?


View Complete Post


More Related Resource Links

SQLServer2008 job created by Copy DataBase Wizard fails - cannot determine if job owner has server a

  

Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in application log:

SQL Server Scheduled Job 'CopyDatabaseWizard_TUNA_MOJITO_1' (0x64AB69F2880A7E4DA3708546C33DFF40) - Status: Failed - Invoked on: 2010-09-23 17:05:04 - Message: The job failed. Unable to determine if the owner (CBMIWEB\johna) of job CopyDatabaseWizard_TUNA_MOJITO_1 has server access (reason: Could not obtain information about Windows NT group/user 'CBMIWEB\johna', error code 0x5. [SQLSTATE 42000] (Error 15404)).

There is a credential on MOJITO defined for CBMIWEB\johna. There is a proxy on MOJITO that uses that credential. The job has one step and in the properties I have set the RUN AS value for the job to be the name of the Proxy. The proxy is established for SSIS jobs.

The "owner" of the job is also CBMIWEB\johna which is a domain userid in the local Administrators group of each machine (both TUNA and MOJITO). This userid has been granted the permission to Logon as a Batch Job on both servers.

TUNA is a Windows 2000 standalone server; MOJITO is Windows 2003. I can logon to each server as CBMIWEB\johna.

I don't know what else to do.


database interface design question

  

For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?

Thanks for any feedback.


How to determine if current SQL User is admin or owner?

  
I wish to determine, from my C# application, if the current user has admin or owner rights to the database they are connected to. I beleive I have all the information required: Servername Database name Windows/Database auth username (If database auth) password (if database auth) I'm trying to find a way that using the smo objects (smo.user), but as of yet I cant quite work it out: - How to get the appropriate user - How to determine if that user is an admin/owner. Any tips would be appreciated. If I have posted to the wrong forum, let me know - I couldnt find one that was obviously more appropriate. Thanks.

Unable to install SP3 on SQL 2005 due to Database Services language being blank

  
Hi all,   I have an issue that requires me to upgrade to a later SP (currently on RTM), but when I try to install SP3 Database Services cannot be ticked. Upon inspection I see that its reporting "This update requires language ENU.  The language for this product instance MSSQLSERVER is . Download the upadte for langage .", when I check teh Language field to the right it is blank, other parts however are fine and can be upgraded. Can you advise please as I don't know how to manually set the language (which is reported inside SQL itself as English (United Kingdom)) and I cannot un/reinstall. Thanks, John

database design for multiple vendors

  
 I have constructed a simple database schema with one vendor.now i would like to add multiple vendors who can/may provide similar products. so i am looking for a design that lists products,there attributes and can be filtered on respective Product Sizes,Brand,Colour easily.    

Problems with SSRS 2008 Install when configuring a back-end database on a SQL Server 2008 R2 environ

  
We are tyring to configure SQL Server Reporting Services (SSRS 2008) not the R2 version with a SQL Server 2008 R2 version of database. We are facing error when the configuration manager within SSRS tries to execute its scripts against the database. Do you think that SSRS 2008 may have trouble using a SQL Server 2008 R2 version as the back-end? Also, what kind of permissions does the ID installing SSRS needs to have on the SQL Server database ?  Not much is available in the documenation or online.

VS 2010 could not find database at design time

  
Hi all, I'm having this problem.... Scenario: C# 2010, WPF, SQL Compact 3.5 SP2. I'm working at a wpf window which loads records from a SQL Compact DB and shows data in textboxes. At runtime everything works perfectly but since this morning (working on it last 2 days) i'm not able to edit the window at DesignTime. As soon as I open the window with the wpf editor I got the error (translating from Italian): "Impossible to find the database. Check the database path. [Data Source = C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\thedbfile.sdf]" Now, in settings and app.config I have the connection string which is something like Data Source=|DataDirectory|\thedbfile.sdf I don't understand why and where NOW (only since this afternoon) at Design Time VS look that path for the database, while at RunTime it's ok. Again, I'm using Datasets, and I can preview data, ecc., as said everything is ok except the edit of the window which crash with this error.... thanks

what is the better design for location of system database data / log files and user data/log file,

  
is there a guideline for better performance for system database data location log location, like tempdb location etc. also better location for user databases/data and log.

Need Suggestion for Database Design ...

  
Hi folk..i want suggestion to design my database tablesi have senario likehere i have a job which will start and then completeso i have fields like StartTime, CompleteTime to store both timestamp...now i need to find the time consumed in this process [(CompleteTime - StartTime) Hrs:min:Sec]so i have two optionshave a field in database Table which will calculate the ConsumedTime for each recordwhen i need to display the consumedtime, i will calculate the differencee.from above which is better.??Assumptions :The table will have a large number of recordsThanks

Database design for treeview and content

  
HiI"m student and need help to design a database for treeview and some content.I need a database design with treeview and it's childnodes,  different content for each node, and modules for each page, like search, contact form and etc... with ability to turn it on and off.Maybe you can show me the way or maybe you have some good links for database design. Any help would be appreciated.THANKS

Database Design

  

hi....

I am creating a very high level relational database diagram for attendance and payroll system.

 

so far I have taken these table into account .

Employee

Attendance

Leave

Department

Company

Payslip

....I am confuse in salary process how to store details related to that...and with which tables it would have relations.Here I want salary process to be done and also payslip has to be generated.

 

Thanks In Advance. 

 


Dental Database Design Help

  

Currently i doing dental appointment website for my lessons, and i having problem in database design. The major of the database is for appointment booking and view information.

The flow

Admin doing the registration for patient, admin, dentist.

Patient login > view dentist > view appointment > make appointment   or view treatment comment

Dentist login > insert patient treatment comment   /   view appointment

Admin > view appointment > Delete appointment and others stuff like report


While creating the dental user table, should i include the dentist into dental user table?Should i create 1 more table for registration ?

I having problem in linking all the table ..Kindly if you could help me in giving suggestion / ideas. Thank you.


Dentist Table

Dentist ID (Primary Key)

Dentist Name

Dentist Specialize

Dentist Contact Number

Dentist Email

Dentist Job Description

 

Appointment Table

Appointment ID (Primary Key)

Dentist ID (Foregin Key)

Appointment Time

Appointment Date


Dental User Table

Username

Password

Name

Identification Card Numner

Contact

failed to create configuration database on Sharepoint 2010 beta install under Windows 7

  
sharepoint configuration wizard at final step issued message as follows:

failed to create the configuration database.

an exception of type system.io.filenotfoundexception ws thrown.  additional exception informaion. could not load file or assemble 'microsoft.identity.model. version=1.0.0.0,culture=neutral, publickeytoken=31bf3856ad364e35' or one of it's dependencies. the system cannot find the file specified.

the only option was to 'finish' the wizard and exit without a successful install.

can anyone help me with diagnosing this problem.

i am running windows 7 on a dell machine and installed all the software requirements for sharepoint install. with the exception of a hotfix for sql server which when i followed the lin appeared to be updated to a more recently posted hotfix.  i downloaded this and installed successfully.


thanks

VS 2010 could not find database at design time

  

Hi all, I'm having this problem....
Scenario: C# 2010, WPF, SQL Compact 3.5 SP2.

I'm working at a wpf window which loads records from a SQL Compact DB and shows data in textboxes. At runtime everything works perfectly but since this morning (working on it last 2 days) i'm not able to edit the window at DesignTime.

As soon as I open the window with the wpf editor I got the error (translating from Italian):

"Impossible to find the database. Check the database path. [Data Source = C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\thedbfile.sdf]"

Now, in settings and app.config I have the connection string which is something like

Data Source=|DataDirectory|\thedbfile.sdf

I don't understand why and where NOW (only since this afternoon) at Design Time VS look that path for the database, while at RunTime it's ok.

Again, I'm using Datasets, and I can preview data, ecc., as said everything is ok except the edit of the window which crash with this error....

thanks


Database Design Suggestions Requried

  

Hi All,

I am working on a multi-lingual application

Assume the following:

Database has 50 tables and application has to support 5 languages

Which is the best way to design the database:
1. Include a langugae column for each table.
    Repeat the values for each language. Say i have a country table which has 100 countries in it. Then my design will contain 500 rows (100 for each langugae)
2. Create a separate table which will contain the translations for all the 50 tables in with a foreign key to the parent table.

Which is more efficient out of the above two.


Thanks

Chandra


Estimating Web analytics database sizes Sp2010 new install

  

Hi

Does anyone know, if we know the number of expected users, number of documents and general usage of a SP2010 system, how I could estimate the sizes of the 2 web analytics databases please? I'm trying to get a very rough idea of SQL db sizing and this part of the process has me stumped. I have spent a lot of time reading all the MS whitepapers and they are good for size estimation except for these 2 databases.

Any help much appreciated.

Thanks in advance,

SG 


Worker & Location Database design question

  

Hello to forums :)

Hi,

I have a simple question on design.

A company has several 'Worklocations'. Each location employs several workers. Every worker can be associated with multiple locations.

So, I have decided to create below tables. please letme know if there is a better way to design it

worker table
wid (primary)
fullname

location table
lid (primary)
Name

workerlocations (WID+LID => primary key)
WID
LID

Is this sounds right for you guys? let me know


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend