Hi folks, i need ur guidance.
I have a few DDL and DML scripts which i want to be automatically applied during MSDE setup; or an .MDF file be attached automatically. Please suggest an easier way!
Howdy!
I have setup a custom Thesaurus for use with SQL Full Text Index (2008). For example I have the following terms :
<expansion>
<sub>400v</sub>
<sub>400volt</sub>
<sub>400 volt</sub>
<sub>415v</sub>
<sub>415volt</sub>
<sub>415 volt</sub>
<sub>3 phase</sub>
<sub>3phase</sub>
<sub>three phase</sub>
</expansion>
When I issue a search for "415 volt" I am getting matches on records with "3" in the data, not just "3 phase" - example query below :
select tblp.productid, tblp.productcode, tblp.description, KEY_TBL1.RANK
from tblProduct tblp
INNER JOIN FREETEXTTABLE(tblProduct, description, '"415 volt"') AS KEY_TBL1 ON tblP.ProductID = KEY_TBL1.[KEY]
ORDER BY KEY_TBL1.RANK DESC
It is returning items that don't have the word "phase" in at all and just have "3"! I have had to take all numbers out of the stop list as we sell a lot of technical items that will be searched for by size / voltage etc.
was installing MSDE for use with Web matrix
thot had done all correctly ie the setup.exe sapwd=xxxxx securitymode=sql from the command prompt
was told that setup has failed
where is the problem
Hello:
I had partitioned my harddrive to have both XP PRO and Red Hat. Got fed up with all that and so used Partition Magic 8.0 to repartition the drive to be one 16 Gig drive. I still have over 8 Gig left on it even after installing VS .NET on it.
I have successfully installed Visual Studio .NET Pro 2003 on it and I can now write programs in VB and see it on my intranet at c:/wwwroot/.
I am now trying to install MSDE 2000 for Developers Using VS .NET. I have downloaded the file from Microsoft and then when I go to install it on my hard drive it tells me it cannot; I have to free up 92.44 Megs for it to be able to extract it to my c drive.
I am a newbee and any help will be GREATLY appreciated!!
i got prob running setup in MSDE ,
there r options to set in setup.ini to enable setting the parameter in MSDE after installed
but it cant run
i use
[Options}
SAPWD=123
after install the sapassword still null,seems like no effect
i've try running from prompt setup.exe /SAPWD 123 too
I am using VB.net to build ASP.net pages. I finally decided it was time to start using SQL server based code. So, I installed MSDE....or so I thought.
I have the server Icon in the bottom systray and it's green and seems to be running.
I have been able to use Microsoft Access' Database Upgrade Wizard to create BB.adp file.
An in VB.net I see a master.dbo connection in Server Explorer.
But I can't figure out how to access the database via the SQL server. When I right click on Server Explorer....the Create a New SQL database menu item is greyed out.
My concern is that my installation is not complete and/or I don't know how to locate and verify the server.
Any help would be appreciated. Thanks
I'm trying to setup the ASP.Net forum on my local XP Pro PC and am having problems with MSDE security. I had an old version of MSDE on the PC and uninstalled it and downloaded/setup the version on the download page with the forum.
Looking at the MSDE readme I did the Windows Authentication mode instead of the mised mode - was that wrong?
When setup tries to setup the DB I get the log entry:
Determined SQL Server version (8.00.194).
[Fail] Could not add ASPNET user to SQL Server.
SQL Server does not exist or access denied.
The server is up and running and I have already used another tool to setup its DB so the server is up an running and functioning fine.
I have search around on the net about MSDE persmissions but the hits have not been helpful - they usually refer to client tools not provided with MSDE. Even if I could find instructions on setting up a user the ASPForumSetup doesn't say what user name or permissons are needed.
I can't find any spot in the XP Pro environment to setup access permissions to MSDE - is finding that the key? My login is a member of the Administrators group.
Help!
Here is my experience with installing MSDE.
I'm leaning C# and ASP.NET at the same time using the book "Microsoft ASP.NET Programming with Microsoft Visual C# .NET Step by Step". In Appendix C, P 577, it says to locate setup.exe under …Microsoft Visual Studio .NETSetupMSDE and "run setup.exe to install MSDE."
This was my first mistake, because there are more recent versions available with security patches (for the slammer virus). I have been unable to successfully update the old version. The install program for MSDE has got to be a hackers delight because only a hacker can make it work. I decided to uninstall the old version of MSDE 2000 and install the latest download from the MSDN website. The new version would get most of the files installed and then rollback the install, removing all the files. When I tried to reinstall the old version, it did the same thing. At least the new version requires a password parameter for the sa user. The bad news is that the new password is ignored. Since I already installed the first version with a blank sa password by running setup.exe with no parameters the password will remain blank until I change it using the user friendly osql command line utility. More about osql later…
Here is how I solved the rollback problem:
I first (after many hours trying to modify the registry to clean up the mess Windows uninstaller left there) used the command line switch /L*V <your logfile name> to get a verbose log file. I noticed a property listed called "Disablerollback" this was set to 0. So, I ran setup on the command line as below (all one line):
>setup DisableRollback=1 /L*V "C:Program FilesMicrosoft Visual Studio .NETSetupMSDEsetupbat.log" SAPWD="ignored password"
The setup still failed, but its tracks were preserved for XP to complain about on system restart.
I then restarted the system and logged in. XP threw an error dialog box with the message "Your server installation is either corrupt or has been tampered with (unknown package ID)…" I clicked OK and waited a few extra minutes for XP to finish logging me in.
After logging in, I closed the Service Manger from the taskbar notification area. I then deleted the folders 80, and MSSQL (name of default instance) from the target install directory. Finally, I ran setup.exe again as shown:
>setup /L*V "C:Program FilesMicrosoft Visual Studio .NETSetupMSDEsetupgood.log" SAPWD="ignored password"
This time, after restarting, my old MSDE worked. This approach seems to only work with the first old version of MSDE that was shipped with Visual Studio .NET. I still have yet to figure out how to upgrade and get MSDE to work again.
Once you get MSDE to work, here are some tips on how to administer it using the osql command tool.
To change the sa password do the following (use null for a blank password):
>osql -U sa
Password:
1> sp-password @old=null, @new='newpassword', @loginame='sa'
2> go
Password has been changed
3> quit
On page 113 of the authors' first attempt with the book "Microsoft ASP.NET Programming…", the hacks wrote:
Set up the SQL Server session state database by running the InstallSQLState.sql batch (located in …) against the SQL Server you plan to use. (For more information about running batch statements, check with your database administrator or the SQL Server Books Online.)
Here is how to do it with osql:
> osql -S MSSQLSERVER -U sa -i InstallSQLState.sql
For less characters than it took to write the last parenthetical sentence, they could have just given the same example I supplied here.
If you want a graphical interface to administer you MSDE server, try downloading the small package for "Microsoft SQL Web Data Administrator" from Microsoft's website. This even comes with a modern installer. Here are some tips on how to connect to your locally installed MSDE using this utility:
The main dialog just requires that you click the start button. A login page comes up. To log in as sa, do the following:
? Click the "SQL Login" radio button.
? Under "Please enter a SQL Server name:" fill in the following text boxes:
? Username: sa
? Password: [your password | leave blank if no password is set]
? Server: (local)
This should get you to the server tools page. Click "Security", then Logins. Now, on the Logins page, you can add new users. If you install MSDE for mixed mode, you can add "Windows Integrated" user accounts. This best since you won't have to put passwords in your code to allow database access to these users. To add a user, click on "Create New Login". Set Authentication Method to "Windows Integrated" in the combo box. For Login Name you need to use the form <computername><username> . For example, "MSSQLServerDan".
If you did like I did, and installed MSDE in SQL login mode only, you can do the following registry hack to change it to mixed authentication mode:
1. Locate either of the following subkeys (depending on whether you installed MSDE as the default MSDE instance or as a named instance:
HKEY_LOCAL_MACHINESoftwareMicrosoftMSSqlserverMSSqlServer
-or-
HKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL Server<Instance Name>MSSQLServer
2. In the right-pane, double-click the LoginMode subkey.
3. In the DWORD Editor dialog box, set the value of this subkey to 1. Make sure that the Hex option is selected, and then click OK.
4. Restart the MSSQLSERVER and the SQLSERVERAgent services for this change to take effect.
Try this link for more details:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322336
Hello:
I have extracted the files from the Microsoft download and am all ready to run SETUP for the MSDE 2000 release A for Visual Studio .NET 2003 Pro.
Is there anything I need to know about or run or configure for it all to work?? I am a newbee and I am the only user on my XP Pro machine under Administrator.
Thank you in advance for any pointers.
Hello,
OS: Windows XP Embedded
MSDE: 2000 SP3 to SP4
I want to avoid reboot after upgrading MSDE from SP3 to SP4.
setup.exe seems to no option to avoid reboot.
The resason to avoid reboot is continue to do some process after upgrade MSDE.
Regards,
I have the following command in a .bat file
osql -E -S localhost sp_grantlogin 'GREGASPNET'"
What I would like to do is replace GREG with the name of the local computer this .bat file is being run on.
Is there any string for this... i.e [LOCALMACHINE]ASPNET or something like that?
Greg
is it possible? Thanks.
View 1 Replies View RelatedI have the following .bat file that I call to register users to my MSDE instance...
echo osql -E -S %COMPUTERNAME%OfficiumInstance -Q "sp_grantlogin '" + %COMPUTERNAME% + "ASPNET'"
echo osql -E -S %COMPUTERNAME%OfficiumInstance -d Officium -Q "sp_grantdbaccess '" + %COMPUTERNAME% + "ASPNET'"
echo osql -E -S %COMPUTERNAME%OfficiumInstance -d Officium -Q "sp_addrolemember 'db_owner', '" + %COMPUTERNAME% + "ASPNET'"
My question is how do I correctly append %COMPUTERNAME% as a string to
I have tried using + signs...
"sp_grantlogin '" + %COMPUTERNAME% + "ASPNET'"
But that doesn't work.
I have looked for .bat file tutorials on the web but can't find the correct way to do this.
Greg
I must install web applications on many servers
how can I create a MS SQL database at setup ?
thank you
creating a custom column that will put a list of 5 values for each unique value(or in this case Employee).
So I have a Employee table were I pull a list of all active employees -
Example -
024Swanson, Ronrswanson@tv.com
026Donaughy, Jackjdonaughy@tv.com
028Scott, Michaelsmichael@tv.com
What I want to do is add a column that has 5 values and create a row for each value
I want it too look like this -
024Swanson, Ronrswanson@tv.com a
024Swanson, Ronrswanson@tv.com b
024Swanson, Ronrswanson@tv.com c
024Swanson, Ronrswanson@tv.com d
024Swanson, Ronrswanson@tv.com e
[Code] ....
Currently all my query looks like is this -
SELECT EmpID, LastFirst, Email
FROM dbo.EmpList
WHERE (Active = 1)
Hello everyone!
Even though I am not "new to SQL Server", my experience in working with it has ebbed and flowed, and working with SQL Server is not something that happens for me even on a monthly basis.
I work as an in-house programmer for a financial investment company and I have been asked to work on a database that is to hold financial data.
One of the requirements for the tables has been that the Primary Key should be [name_of_the_table] + [Identity].
So, for example, for table "tblEquities", the values of the Primary Key would be:
PK
-------
tblEquities1
tblEquities2
tblEquities3
tblEquities4
tblEquities5
My questions are:
1) Is it possible to achieve this by using just one column, as in defining a formula for the "Computed Column Specification" , something that would look like "'tblEquities' + Identity()"?
2) If the above is not possible, I assume it's much easier to just define a column as being Identity column and then create a 2nd computed column that would aggregate the name of the table with the value in the Identity column, so that I end up with a column holding the desired values? (I guess it would look something like
"'tblEquities' + [Identity]")
Also, I have been asked to find out what SQL 2005 have/offers, in term of guaranteeing referential integrity. Are the "Database Diagram", as well as the "Relationships" dialog box, the tools that would meet that criteria or does SQL 2005 contain other tools that would help in this regard?
Thank you!
I have a package that is going to have roughly 20 sequence containers in it. Each of these containers is going to have the same start task and the same end task. The data flow task(s) in each sequence container will differ. So I was thinking I would create a custom sequence container that would implement the common steps I need in each of my containers. I started to create a task that would inherit from Sequence, but I found that it is sealed. Bummer.
What is involved in creating a sequence task by inheriting from Task? I see that Sequence implements IDtsSequence. But looking at this interface, it seems like I would have to build the logic to execute the workflow contained in my sequence.
Any pointers?
-Darrell
Is it possible to create relationships between tables using foregin keys with MSDE. I have looked for any information and can't seem to find anything.
View 3 Replies View RelatedI have MSDE installed on my sistem, and I need to add a new user.How do I go about doing this?
View 2 Replies View RelatedI currently have a website which is using ASP.NET 2.0, C#, and SQLServer 2005. The website will be used to enter grants for auniversity. When a new grant is entered, I need to generate a primarykey. The primary key will need to follow the format: Two digit forfiscal year, then number of the grant for that year. Example:Year 08 and 14th grant of the year would be: 0814How can I implement this. Right now, I have a "New Grant.aspx" pagewith a Submit button. I am guessing the date is going to be formattedin C#. How can I check what the last primary key in the database is?Also, it seems to me that SQL Server insists that the primary key be32 bits long, however my primary key will only be 4. How can Ioverride this? Thanks.
View 3 Replies View RelatedI'm trying to create a custom data flow destination, and it has a custom property that needs to get value from variable(similar to the FileNameVariable property of Raw File Destination), how can I do that?
View 5 Replies View RelatedHello,
The main problem I am currently facing is that I do not have the following directory to place the DLL file: C:Program FilesMicrosoft SQL Server80ToolsReport Designer. It is the "Report Designer" part that is missing. I tried adding it, but that didn't work.
Any ideas why that is?
Thank you.
-Gumbatman
I would like to write a custom data source component for SSIS. I was wondering if there are any tutorials / examples for this that are available.
Thanks
Microsoft published a "Creating a custom transformation component Walkthrough" published on
http://www.microsoft.com/downloads/details.aspx?FamilyID=1c2a7dd2-3ec3-4641-9407-a5a337bea7d3&DisplayLang=en
Does anyone know where to get the Hands-On Lab Files mentioned?
Thanks
Alex
http://msdn2.microsoft.com/en-us/library/ms345276.aspx
does anyone know where this can be obtained? it did not come with the RTM. it does not seem to be available via download either?
a little help here!
Hi,
I have a 2 custom components - source and destination.
I want to create an error output for each, to allow the users of my component to handle errors the way they choose.
I only found a property in IDTSOuptut90 named isErrorOut - a boolean property indicating whether this output is an error output or not.
Does anyone have additional documentation / articles / code samples regarding how to really populate the rows in the error output?
Thanks
Hi
View 1 Replies View RelatedHello all, I am developing my own custom export type via the IRenderingExtension interface, and I am having a fundamental problem getting it to work.
I followed this guide written by James Yip, http://forums.microsoft.com/TechNet/AddPost.aspx?ForumID=82&SiteID=17, and managed to compile my SampleRenderer class and properly configure SRSS so that my 'Sample' export format is now available in the export dropdown in Report Manager.
However, upon actually exporting a report, the result is a blank file. I have absolutely no idea why the stream I create isn't getting through to the final file.
Here is my render method:
Code Block
public bool Render(Microsoft.ReportingServices.ReportRendering.Report report, System.Collections.Specialized.NameValueCollection reportServerParameters, System.Collections.Specialized.NameValueCollection deviceInfo, System.Collections.Specialized.NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
{
System.IO.Stream stream = null;
System.IO.StreamWriter streamWriter = null;
try
{
stream = createAndRegisterStream("users", "txt",System.Text.Encoding.ASCII, "text/plain", false, StreamOper.CreateAndRegister);
streamWriter = new System.IO.StreamWriter(stream);
streamWriter.WriteLine("Hello???");
}
finally
{
if (streamWriter != null)
{
//streamWriter.Close();
//closing the stream here results in an exception
}
if (stream != null)
{
//stream.Close();
}
}
return false;
}
Any ideas on what I am doing wrong here?
Thanks,
Dan
I would like my transformation to automatically create an output column for each input column. Any tips? I can't seem to determine which event to listen to or method to override.
View 3 Replies View RelatedHow to Deploy SQL server Database to another PC, How to create apackage that craetes Database as well as ODBC driver for accessing dataat enduser PC, using .Net VB
View 2 Replies View RelatedI want to configure an alert which notifies me if any of my database log files size exceeds a certain threshold percentage.
View 6 Replies View RelatedHow would I set up a sql server database based on the following problem? I will be creating a poll based on 9 dimensions that compare two companies.
honda yamaha performance features reliability conformance durability serviceability aesthetics safety other perceptives
The values stored would be 1 or 0 so the values can be totalled. The user will be using a web pageand will select a radio button per dimension for either honda or yamaha. Would this work?
tbl_companiescompanyid int pkcompanyname varchar
tbl_resultsresultsid int pkp int --performancef int --featuresr int --reliabilityc int --conformanced int --durabilitys int --serviceabilitya int --aestheticssf int --safteyop int --other perceptivescompanyid int -- fk to tbl_companies.companyiduserid int -- fk to tbl_users.userid
tlb_usersuserid int pkusername varcharuserip varchar
How would I set up a sql server database based on the following problem? I will be creating a poll based on 9 dimensions that compare two companies.
honda yamaha
performance
features
reliability
conformance
durability
serviceability
aesthetics
safety
other perceptives
The values stored would be 1 or 0 so the values can be totalled. The user will be using a web page
and will select a radio button per dimension for either honda or yamaha. Would this work?
tbl_companies
companyid int pk
companyname varchar
tbl_results
resultsid int pk
p int --performance
f int --features
r int --reliability
c int --conformance
d int --durability
s int --serviceability
a int --aesthetics
sf int --saftey
op int --other perceptives
companyid int -- fk to tbl_companies.companyid
userid int -- fk to tbl_users.userid
tlb_users
userid int pk
username varchar
userip varchar